Fixed Beast Mode for Percent of Category
We're trying to get a percent of the total for each series category on this chart by using a fixed function beast mode:
We're displaying the number of unqualified leads on the y axis and using the fixed beast mode as a tooltip field used in the data label settings. On the 27th the % should be around 23% as the total leads created that day were 642 and the number of the leads disqualified is 149. What am I doing wrong here?
Answers
-
I think you are trying to do too much in one column. I would break those out into separate columns so you can see the information in a table display across all companies. Then filter or group by.
Lead_Count:
CASE WHENStatus
='Unqualified' THEN COUNT(Lead ID
) ENDLead_Total:
CASE WHENStatus
='Unqualified' THEN SUM({amount}) ENDThen you find rate by dividing whatever….such as Lead_Count/Lead_Total.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
This wouldn't work for my use case but I did find a solution by wrapping the denominator with the fixed by function and adding the date being used as the filter on the card to the fixed by statement:
COUNT(DISTINCT CASE WHEN
Status
= 'Unqualified' THENLead ID
END) / (SUM(COUNT(DISTINCTLead ID
) FIXED(BYCompany
,Lead.CreatedDate
)))1
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 663 Datasets
- 119 SQL DataFlows
- 2.3K Magic ETL
- 823 Beast Mode
- Visualize
- 2.6K Charting
- 86 App Studio
- 46 Variables
- Automate
- 194 Apps
- 483 APIs & Domo Developer
- 87 Workflows
- 23 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 117 Domo Everywhere
- 283 Scheduled Reports
- 11 Software Integrations
- Manage
- 143 Governance & Security
- 11 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 116 Community Announcements
- 5K Archive