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