Year over Year totals by month and sort

user060040

 

I am trying to create a bar chart that contains totals for 2 types of requests and their lines of business.

This card will be a monthly card and would show a comparison of current year versus last year for that particular month. 

 

Example:

y axis

LOB A + Request Type A total for 2020

LOB A + Request Type A total for 2019

LOB B + Request Type A total for 2020

LOB B + Request Type A total for 2019

Total Request Type A for 2020

Total Request Type A for 2019

 

LOB A + Request Type B total for 2020

LOB A + Request Type B total for 2019

LOB B + Request Type B total for 2020

LOB B + Request Type B total for 2019

Total Request Type B for 2020

Total Request Type B for 2019

 

I have the items in Bold already complete but am having a hard time incorporating the Total Request types into the same card.

 

Attached is an example of what it should look like. 

Thanks!

 

GrantSmith

Hi @user060040 

Without seeing how your data is structured it's difficult to give an answer to your question as the format will dictate how you can solve this problem. Could you also post some pseudo data of how your dataset is structured?

 

Is it structured like:

LOB

Request Type

Year

Count

 

Or

 

LOB

Request Type A Count

Request Type B Count

Year

 

Or

Reuqest Type

LOB A Count

LOB B Count

Year

user060040

It is

Is it structured like:

LOB

Request Type

Year

Count

 

Right now I have the y axis a beast mode concat of LOB | Request Type

x axis is the count of the beast mode field above

series is the created year

jaeW_at_Onyx

To get a Total Row that's not a 'total row' in analyzer, you'll have to do a little tomfoolery with the data.

 

Just APPEND a copy of your data to the bottom of your data, but replace LOB value with the constant 'Total'.