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
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(CASEWHEN ((DateDiff(AddDate(Current_Date(),-1),`TransactionDate`) <= 91) AND (DateDiff(AddDate(Current_Date(),-1),`TransactionDate`) >= 1)) THEN `Fee$` END) / SUM(CASEWHEN ((DateDiff(AddDate(Current_Date(),-1),`TransactionDate`) <= 181) AND (DateDiff(AddDate(Current_Date(),-1),`TransactionDate`) > 91)) THEN `Fee$` END))*100-100),'% Quarterly ',FLOOR((SUM(CASEWHEN ((DateDiff(AddDate(Current_Date(),-1),`TransactionDate`) <= 91) AND (DateDiff(AddDate(Current_Date(),-1),`TransactionDate`) >= 1)) THEN `Fee$` END) / SUM(CASEWHEN ((DateDiff(AddDate(Current_Date(),-1),`TransactionDate`) <= 451) AND (DateDiff(AddDate(Current_Date(),-1),`TransactionDate`) > 361)) THEN `Fee$` END))*100-100),'% Annually')
@CelineH, did any of the above replies help answer your question?
Yes it finally worked!
thanks!
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?
Thanks!!! it worked perfertly