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%
1 -
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.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 304 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 105 SQL DataFlows
- 645 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 773 Beast Mode
- 74 App Studio
- 43 Variables
- 726 Automate
- 185 Apps
- 466 APIs & Domo Developer
- 61 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 402 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 9 Software Integrations
- 135 Manage
- 132 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive