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.6K Product Ideas
 1.6K Ideas Exchange
 1.4K Connect
 1.1K Connectors
 286 Workbench
 4 Cloud Amplifier
 6 Federated
 2.7K Transform
 91 SQL DataFlows
 583 Datasets
 2.1K Magic ETL
 3.6K Visualize
 2.4K Charting
 645 Beast Mode
 34 App Studio
 33 Variables
 628 Automate
 159 Apps
 430 APIs & Domo Developer
 37 Workflows
 2 DomoAI
 31 Predict
 12 Jupyter Workspaces
 19 R & Python Tiles
 377 Distribute
 107 Domo Everywhere
 266 Scheduled Reports
 4 Software Integrations
 104 Manage
 101 Governance & Security
 6 Domo University
 15 Product Releases
 Community Forums
 39 Getting Started
 29 Community Member Introductions
 93 Community Announcements
 4.8K Archive