Year over Year totals by month and sort

 

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!

 

Tagged:

Comments

  • GrantSmith
    GrantSmith Indiana 🔴

    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:

    LOBRequest TypeYearCount

     

    Or

     

    LOBRequest Type A CountRequest Type B CountYear

     

    Or

    Reuqest TypeLOB A CountLOB B CountYear
  • It is

    Is it structured like:

    LOBRequest TypeYearCount

     

    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
    jaeW_at_Onyx Budapest / Portland, OR 🟤

    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'.