Ask Search:
Pamela WakemanPamela Wakeman 

Row level Formulas in Dashboards

Can Row Level Formulas in Reports be shown in Dashboards? This feature is now generally available, but this this info is not available in the row level formulas limitations article below. https://help.salesforce.com/articleView?id=reports_formulas_row_level_limits.htm&type=5
Best Answer chosen by Pamela Wakeman
Steve MolisSteve Molis
Okay, so you're essentially counting the number of days between to Date Fields. 

Unfortunately I don;t think this one is gonna be doable usig a Row Level Formula in a Dashboard Component. 

You're probably going to need a Formula Field on the Object then display it at a Summary Level Grouping   

All Answers

Coby PressCoby Press
Have ago. I didn't think so though.
it takes a matter of minutes to test it.
if it doesn't work- it's a very simple answer or no, as there won't be any config to get it there.
you might be able to use a VF page to display it.
Steve MolisSteve Molis
I don't think that's gonna be possible with a Row Level Formula.  Can you elaborate on exactly what you're trying to do and post a screenshot of the Report, Settings, and Filters that you're using, the results you're getting, and a mock-up of what you want?  For questions related to Reports and Dashboards those are really helpful
Pamela WakemanPamela Wakeman
Thanks Steve, Trying to understand why the row level formula (SLA (MQL > SPAL) doesn't show up in my Lead Flow Dashboard. I'm using the same table format in the dashboard.
Steve MolisSteve Molis
Can you post a screenshot of the Report that you're using that shows the Formula?  I'm not saying it's gonna be possible, but there might be a work-around using a Formula field or something.  But I can only guess without seeing it 
Pamela WakemanPamela Wakeman
I will add a custom field if I have to, but I thought Row Level Formulas were created to avoid this. Not sure hoe practical it is to create reports like this if they can't be shown in a dashboard.  
 Matrix report with row level formula
Steve MolisSteve Molis
Okay, so you're essentially counting the number of days between to Date Fields. 

Unfortunately I don;t think this one is gonna be doable usig a Row Level Formula in a Dashboard Component. 

You're probably going to need a Formula Field on the Object then display it at a Summary Level Grouping   
This was selected as the best answer