cancel
Showing results for 
Search instead for 
Did you mean: 

Ranking in SAC not as sophisticated as Explorer?

keithfisherdsc
Participant
0 Kudos
476

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

Accepted Solutions (0)

Answers (2)

Answers (2)

keithfisherdsc
Participant
0 Kudos

the main issue is that SAC does not allow me to add a dimension to the ranking to make it more specific. In Webi and Explorer you can do this:

and it's simple enough.

SAC doesn't have the same options and just filters for the top (n) data points in the chart, unless I am missing something

VijayetaSharma
Active Contributor
0 Kudos

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.