LinkedIn
Twitter
Hello Community!
I am struggling with Chart UX Tools trying to create a very specific kind of chart: a stacked histogram (created using Google Sheets)
Context
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.
- Region
And a simple Enum Column for - Month
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.
Thank you!
