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
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 202 Visualize
- 255 Beast Mode
- 2.1K Charting
- 12 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 180 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive