Help

Hello,
I need some help.
I made a few calculations in beast mode (Avg Bill Rate, Avg payRate, markup)that I need to use for reporting. Here's how I want my report to look like. How do I create create this metric list ? Kindly help.
Category | Metric | Jan | Feb | Mar | …Dec | Total |
---|---|---|---|---|---|---|
Category-1 | Avg bill rate | |||||
Avg pay rate | ||||||
Markup | ||||||
Category-2 | Avg bill rate | |||||
Avg pay rate | ||||||
Markup | ||||||
Best Answers
-
You would use the chart type "Pivot Table" found in the Chart Types section in Card Analyzer (see below)
In your pivot table you would drag your category field into the "Rows" input. Drag the Date field into the "Columns" input and lastly drag your beastmode calcuations into the "Values" input.
If I solved your problem, please select "yes" above
1 -
@learnDomo What does your dataset look like? To get the desired visual, you may need to change how your data is structured. If you can get your data into a table with this structure (see 1st image) then you can add the columns into the Analyzer for the pivot table chart type as follows (see second image).
0
Answers
-
You would use the chart type "Pivot Table" found in the Chart Types section in Card Analyzer (see below)
In your pivot table you would drag your category field into the "Rows" input. Drag the Date field into the "Columns" input and lastly drag your beastmode calcuations into the "Values" input.
If I solved your problem, please select "yes" above
1 -
@learnDomo What does your dataset look like? To get the desired visual, you may need to change how your data is structured. If you can get your data into a table with this structure (see 1st image) then you can add the columns into the Analyzer for the pivot table chart type as follows (see second image).
0 -
@ColemenWilson ,thank you so much for the idea, though I was just trying to run away from this presentation. I guess I shall maintain the same idea as your suggestion.
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 656 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 811 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 80 App Studio
- 45 Variables
- 771 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 77 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive