Can I have 2 numbers (% and absolute value) in the summary number section of a card?
Best Answers
-
Hi @CelineH,
There is a way to do that through a Beastmode. Basically you will need to create a formula concatenating the folowwing things:
CONCAT(
(FormulaForThePercentage),
'% sign plus the name you give your calculation',
(FormulaForTheAbsoluteValue),
'Name you give your formula')
ones you create your beastmode make sure to check the box "Apply to Summary Number" and save.
recently I posted about this, here it is the link
https://dojo.domo.com/t5/Domo-Dojo-Contest-January-2016/quot-Best-Beast-Mode-Formula-quot/idi-p/7840
This is an example , a formula I currently use. hope it helps you
CONCAT(FLOOR(
(SUM(CASE
WHEN ((DateDiff(AddDate(Current_Date(),-1),`TransactionDate`) <= 91) AND (DateDiff(AddDate(Current_Date(),-1),`TransactionDate`) >= 1)) THEN `Fee$` END)
/
SUM(CASE
WHEN ((DateDiff(AddDate(Current_Date(),-1),`TransactionDate`) <= 181) AND (DateDiff(AddDate(Current_Date(),-1),`TransactionDate`) > 91)) THEN `Fee$` END))*100-100)
,'% Quarterly ',
FLOOR(
(SUM(CASE
WHEN ((DateDiff(AddDate(Current_Date(),-1),`TransactionDate`) <= 91) AND (DateDiff(AddDate(Current_Date(),-1),`TransactionDate`) >= 1)) THEN `Fee$` END)
/
SUM(CASE
WHEN ((DateDiff(AddDate(Current_Date(),-1),`TransactionDate`) <= 451) AND (DateDiff(AddDate(Current_Date(),-1),`TransactionDate`) > 361)) THEN `Fee$` END))*100-100)
,'% Annually')Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'2 -
Add a ROUND(XXXX , 4) to the equation. CONCAT( ROUND((SUM(`Calculation Use 1`)/COUNT(`Phone`)),4)*100,'% Conversion Rate',' ',',', COUNT(`Phone`),' ','Total Leads')Dojo Community Member
** Please like responses by clicking on the thumbs up
** Please Accept / check the answer that solved your problem / answered your question.1
Answers
-
Hi @CelineH,
There is a way to do that through a Beastmode. Basically you will need to create a formula concatenating the folowwing things:
CONCAT(
(FormulaForThePercentage),
'% sign plus the name you give your calculation',
(FormulaForTheAbsoluteValue),
'Name you give your formula')
ones you create your beastmode make sure to check the box "Apply to Summary Number" and save.
recently I posted about this, here it is the link
https://dojo.domo.com/t5/Domo-Dojo-Contest-January-2016/quot-Best-Beast-Mode-Formula-quot/idi-p/7840
This is an example , a formula I currently use. hope it helps you
CONCAT(FLOOR(
(SUM(CASE
WHEN ((DateDiff(AddDate(Current_Date(),-1),`TransactionDate`) <= 91) AND (DateDiff(AddDate(Current_Date(),-1),`TransactionDate`) >= 1)) THEN `Fee$` END)
/
SUM(CASE
WHEN ((DateDiff(AddDate(Current_Date(),-1),`TransactionDate`) <= 181) AND (DateDiff(AddDate(Current_Date(),-1),`TransactionDate`) > 91)) THEN `Fee$` END))*100-100)
,'% Quarterly ',
FLOOR(
(SUM(CASE
WHEN ((DateDiff(AddDate(Current_Date(),-1),`TransactionDate`) <= 91) AND (DateDiff(AddDate(Current_Date(),-1),`TransactionDate`) >= 1)) THEN `Fee$` END)
/
SUM(CASE
WHEN ((DateDiff(AddDate(Current_Date(),-1),`TransactionDate`) <= 451) AND (DateDiff(AddDate(Current_Date(),-1),`TransactionDate`) > 361)) THEN `Fee$` END))*100-100)
,'% Annually')Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'2 -
This works great and we have employed situations like this as well. One item to keep in mind, is if you use this, you cannot get these metrics to appear in your Daily DOMO digest. It will not pick up a concat statement. So weight the tradeoff of one card vs. the auto email update of KPI's. No right answer here - just a tradeoff to consider!Dojo Community Member
** Please like responses by clicking on the thumbs up
** Please Accept / check the answer that solved your problem / answered your question.0 -
Yes it finally worked!
thanks!
0 -
Great! could you mark the answer that was the solution. that would help others who come into this post.Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'0 -
CONCAT(
(SUM(`Calculation Use 1`)/COUNT(`Phone`))*100,'% Conversion Rate',' ',',',
COUNT(`Phone`),' ','Total Leads')My only concern right now is the %number is super long and i can't manage to get it rounded. Any suggestions?
0 -
Add a ROUND(XXXX , 4) to the equation. CONCAT( ROUND((SUM(`Calculation Use 1`)/COUNT(`Phone`)),4)*100,'% Conversion Rate',' ',',', COUNT(`Phone`),' ','Total Leads')Dojo Community Member
** Please like responses by clicking on the thumbs up
** Please Accept / check the answer that solved your problem / answered your question.1 -
Thanks!!! it worked perfertly
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 310 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3K Transform
- 113 SQL DataFlows
- 651 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 795 Beast Mode
- 78 App Studio
- 44 Variables
- 755 Automate
- 187 Apps
- 480 APIs & Domo Developer
- 71 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 407 Distribute
- 118 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 141 Manage
- 137 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive