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
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 755 Beast Mode
- 61 App Studio
- 41 Variables
- 693 Automate
- 178 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive