I am struggling with Chart UX Tools trying to create a very specific kind of chart: a stacked histogram (created using Google Sheets)
I have an App for registering sales. The App has a Sales table. Each sale has a Ref column for…
- Agent: Team member in charge of the sale
- Status: Wether the sale has been shipped, cancelled, or is waiting to be confirmed.
And a simple Enum Column for
Im trying to build an interactive dashboard view where the user can pick a Region and/or an Agent, and see the amount of sales per month, by status.
I’ve succesfully managed to build a combination of aggregate histogram (for Total Sales by Month) + pie chart (for Total Sales by Status)… And also splitting up the Sales table into different status-slices to create 4 different histograms with month columns (Total Sales, Cancelled Sales, Shipped Sales…)
You can see a sample APP here.
But as you can imagine… the experience and insights any user could make from any of those two combinations is not the same as depicted in the chart created using Google Sheets.
Is there currently a way to create such charts? Should I start a feauture request instead?
I’ve considered creating a slice of the Sales table based on “user input form based filters”, but taking into account the amount of filters I’d like to include, the UX would turn out to be quite unsatisfactory.