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!
Comments
-
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 **Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
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
0 -
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"0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 544 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 345 Distribute
- 87 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 8 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive