How can I display my buget groups matrixed by year

howto

#1

How can I make a bar graph like the following? I want to display my budget groups on a dashboard that will matrix the budget groups against years. this way I can get a general overview of customers when I filter them to see their product mix growth year over year from a birds eye view. :bar_chart:


#2

Hi,

One way to achieve this is…
Is having year as a dimension, year of transaction recorded on every transaction line and then mapped as a dimension.

Set the period as the entire year date range eg 2015-2018,
Matrix the Year dimension and then select groups dimension and chart it.


#3

That’s what I was thinking… Thanks for the response. I will reach out to support to have that added.


#4

Got what I needed added in. Works Just as planned. Thanks for feedback.