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 712023 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.3K Product Ideas
 1.3K Ideas Exchange
 1.4K Connect
 1.1K Connectors
 281 Workbench
 2 Cloud Amplifier
 4 Federated
 2.8K Transform
 83 SQL DataFlows
 541 Datasets
 2.2K Magic ETL
 3.2K Visualize
 2.3K Charting
 518 Beast Mode
 26 Variables
 555 Automate
 129 Apps
 408 APIs & Domo Developer
 18 Workflows
 28 Predict
 12 Jupyter Workspaces
 16 R & Python Tiles
 343 Distribute
 85 Domo Everywhere
 257 Scheduled Reports
 1 Software Integrations
 81 Manage
 80 Governance & Security
 2 Product Release Questions
 Community Forums
 41 Getting Started
 27 Community Member Introductions
 78 Community Announcements
 4.8K Archive