Fix for concatenated summary number rounding issue - use to articulate data in full sentences
For the past three years we have been using concantinated summary numbers to articulate the results of our multitouch attribuiton models. I hope that sharing these will spark some interest in experimenting with more literary articulations of your data.
We have been experiencing some issues since the update where concantenated summary numbers ignore ROUND() funtion and show many decimal points. Previously calculation on percentage functions in beastmodes have displayed properly prior to multiplciation for the hundred but it seems like now the round must be more specific.
CONCAT( ROUND((SUM(`Calculated Members`)/COUNT(`Gross Response`)),2)*100,'% Unique Members Conversion Rate',',',' ', ROUND((SUM(`Calculated Enrollments`)/COUNT(`Gross Response`)),2)*100,'% Enrollment Conversion Rate'
,',',' ', COUNT(`Gross Response`),' ','Gross Response')
CONCAT( ROUND((SUM(`Calculated Members`)/COUNT(`Gross Response`))*100,2),'% Unique Members Conversion Rate',',',' ', ROUND((SUM(`Calculatied Enrollments`)/COUNT(`Gross Response`))*100,2),'% Enrollment Conversion Rate'
,',',' ', COUNT(`Gross Respone`),' ','Gross Response')
CONCAT(
'Gross Response, ', round(count(`Gross Response`),2), ': ',
round(count(CASE WHEN (`Members Date` < `Leads Date`) THEN `Phone`END )/(count(`Gross Response`)),2)*100 ,'% Previously Converted Member. ',
round(count(CASE WHEN (`Members Date` >= `Leads Date`) THEN `Phone`END )/(count(`Gross Respose`)),2)*100 ,'% Converted Lead. ' ,
round(count(CASE WHEN `Members Date` IS NULL THEN `Phone`END )/(count(`Gross Response`)),2) *100,'% Non-Converted Lead. '
)
CONCAT(
'Gross Response, ', round(count(`Phone`),2), ': ',
round(count(CASE WHEN (`Members Date` < `Leads Date`) THEN `Phone`END )/(count(`Gross Response`))*100,2) ,'% Previously Converted Member. ',
round(count(CASE WHEN (`Members Date` >= `Leads Date`) THEN `Phone`END )/(count(`Gross Response`))*100,2) ,'% Converted Lead. ' ,
round(count(CASE WHEN `Members Date` IS NULL THEN `Phone`END )/(count(`Gross Response`))*100,2) ,'% Non-Converted Lead. '
)
Bonus code, if you retain gross outreach records:
Of the xxxxxx members who received this outreach, xxxxx remained a member xx.x% | xxxx is not currently an active member xx.x%
CONCAT(
'Of the ', COUNT(distinct`Member ID`), ' members who received an outreach, ',
count(distinct (CASE
when `Active = 'Yes' then ` Member ID`
end) ) ,
' remained a member ',
round((count(distinct (CASE when `Active ` = 'Yes' then `Member ID` end) ) /COUNT(distinct`Member ID`) *100),1), '% | ',
count(distinct (CASE
when `Active ` is null then `Member ID`
end) ) ,
' is not currently an active member ' ,
round((count(distinct (CASE when `Active ` is null then `Member ID` end) ) /COUNT(distinct`Member ID`) *100),1), '% '
)
Comments
-
This is a great tip. Thanks for sharing. It did spark some thought around possible improvements to summary numbers. I posted an idea, please upvote here
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive