on 2020 Nov 12 12:36 PM
I'm trying to recreate an Explorer view in SAC and to do this I need to have a stacked bar chart showing values by year/quarter with the bars split by a category dimension.
When I apply a ranking to the chart I want to see the top 5 category dimensions, along with all their results/values - I don't want to see just the top 5 measure results for all the years/quarters and categories.
For example in the Best Run Juice company model I can easily create a chart showing me the top 5 sales people by quantity sold.
When I go to create a chart of year/quarter and quantity sold, then add in sales person as the stack for the bars - and then apply a ranking I am left with only 5 blocks of colour in total.
How to I get this stacked bar chart to show me all the results over the year for the top 5 sales people, and have that be dynamic within the story and model?
thanks
Keith
Request clarification before answering.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I don't think you can archive what you are looking for in SAC yet. Charts do not show options to create stacked bar chart and then split it by dimensions.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
49 | |
10 | |
8 | |
6 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.