Can I have 2 numbers (% and absolute value) in the summary number section of a card?

CelineH

I am looking for a way to have 2 numbers in the summary number section (% and absolute value). How can I display both?

 

Thanks,

Celine

Godiepi

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')

 

Shevy

Add a ROUND(XXXX , 4) to the equation. CONCAT( ROUND((SUM(`Calculation Use 1`)/COUNT(`Phone`)),4)*100,'% Conversion Rate',' ',',', COUNT(`Phone`),' ','Total Leads')

Godiepi

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')

 

Shevy

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!

kshah008

@CelineH, did any of the above replies help answer your question?

CelineH

Yes it finally worked! 

 

thanks!

Godiepi

Great! could you mark the answer that was the solution. that would help others who come into this post.

CelineH

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?

Shevy

Add a ROUND(XXXX , 4) to the equation. CONCAT( ROUND((SUM(`Calculation Use 1`)/COUNT(`Phone`)),4)*100,'% Conversion Rate',' ',',', COUNT(`Phone`),' ','Total Leads')

CelineH

Thanks!!! it worked perfertly