Tool Tips
Answers
-
You'll need to first create a beastmode calculating the percentage and use that as the tooltip field. Make sure you configure the format on the tooltip column as a percentage.
0 -
@ColinHaze You can also try using the %_PERCENT_OF_CATEGORY macro in the Hover Text. There is also a an option for percent of total.
0 -
Is carrier_name your X axis and loads your Y? If so your data is already partitioned by carrier_name. What are you trying to subtotal? Maybe paste a screenshot of your bar graph if you can.
0 -
Here is the graph. I am trying to get 32.71% (which is in the piviot table) to show in the first tier when I hover over Kinard. Concentration is just the % of subtotal in the pivot table.
0 -
Try
sum(sum(cpm_beastmode)) over(partition by carrier_name, month(`fiscal months`)) /
sum(sum(cpm_beastmode)) over(partition by carrier_name, year(`fiscal months`))
0 -
That didnt seem to work. Looking at Kinard for 7-1-2023 that beastmode gave me 17%
0 -
What's your cpm formula?
0 -
SUM(Carrier Pay) / SUM(Total billed miles)
0 -
Hmm I don't know, you can try adding the distinct command as in sum(sum (distinct
cpm formula
)) but I you may have to aggregate that in the ETL first. Or use Michelle's hover text option if that rolls up correctly.0 -
Thank you for trying! Ill keep playing around with it!
1 -
Yeah let me know if you do figure it out please Colin
0 -
Could you walk me through the math for Kinard Trucking for July that you are looking for?
Do you want to see:
(sum of Kinard for July) / (sum of Kinard for entire time period)
(6.64) / (38.13) = ~17%
or
(sum of Kinard for July) / (sum of all carriers in July)
(6.64) / (41.35) = ~16%
Neither of these seem to get to 37%
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1 -
The value I want the chart to display is the CPM(which it is doing correctly) The problem comes in with the hover text.
Here is my logic using a simple example.
For the month of 7/1/2023
Kinard has 34 loads
The other companies like kkw, power logistics, etc… have different # of loads. Lets just say all the loads summed together = 100 so Kinard has 34/100 = 34% concentration. Ideally I want to do this for each month and allow the user to hover over the bar chart and get the % concentration for the month. Does that make sense?
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive