As the title states, I need some help focusing on a segment of the business and showing as a bar graph. The sales rep wants to analyze month by month sales this year over last year. Currently using a custom date range by month, this year over last year but using the Period Variance mode, it will not break it down by month but instead, just show the total for the entire year. There has to be a way for the graph to show each month, this year vs last year.
You can see I’m trying to focus on 4 segments of a particular business. The custom date range of month, this year versus last
I think the issue is the “x” series is grouped by Subclasses rather than time. I had similar challenges, I needed to create a date dimension on the DB which would then swap out the “x” series to being time, however that wont give you precisely what you are after. As a quick win, have you considered Bullet charts using variance mode? they would overlay current vs previous. These are my go to charts for comparisions.
I think if you were to add ‘month’ as a pillar you could then do a matrix variance. This would then show the month across the bottom with a variance between your date ranges. The only downside is that it would total up your ‘subclass code’
The below example is some activity by hour for a monthly date range. As you can see it’s showing my 3 selections as 1 total.
