Do you have something today that is doing this outside of Quickbase you're trying to recreate? At face value I would say that maybe, you could put this in a single report but fundamentally I wouldn't suggest you not do it.
The primary reason is just your Y-Axis is probably going to be all over the place, specifically for any $ values that will far outpace the # of clients and products, but even if you do 2-different y-axis you're still likely to have a wide range between whatever series you choose being clients and products, and secondarily I'm not sure even if you solve for that that you could get it to properly summarize that data by AM while reporting on time.
You could try and get creative with a line and bar chart where you would provide your profit and revenue as the primary y-axis (line chart) and then put the clients / products on the x-axis (bar chart). The only consideration here is that you would need to isolate the unique clients/products in order to have them properly display as a bar chart. You would not be able to put everything as a line provided that you can only do a sum/average aggregation on charts. This probably only solves part of it though in that it is a holistic view of the org and not broken out by AM.
My suggestion would be to flip this around and make it a suite of reports on a single dashboard. You can line up the 3 reports on the same time frame and color scheme for each AM and sort order and then stack them on top of each other to conceptualize the pattern.
------------------------------
Chayce Duncan
------------------------------
Original Message:
Sent: 09-18-2023 11:47
From: Matt Makris
Subject: Help with creating a multidimensional chart
I was tasked with creating a chart with the following information. How would you recommend displaying this in one chart? Is it possible?
- Show profit/revenue assigned to any Account Manager over time (how does their profit and revenue compare to 6 months ago?)
- Show total number of Client records they are assigned to (how does this compare over same period of time)
- Show total number of products they are assigned to that are paused/cancelled (how well do they retain clients)
Topology
Parent: Clients table (contains Assigned AM field, status=active)
- Child: Products table (contains current profit, current revenue, current # of products, status=paused or cancelled)
- Child: Products History table (contains historical info (same fields as Products table)
------------------------------
Matt Makris
------------------------------