# Year over Year totals by month and sort

Member

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:

• Coach

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
**Did this solve your problem? Accept it as a solution!**
• Member

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

• Coach

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

Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨‍💻

**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"