Skip to main content

Hello! So I have a matrix report where the rows are grouped by a bucket field and the columns are grouped by date and then stage (Closed Lost/Closed Won). I have a summary formula for a rolling 6 month win rate:  

 

(CDF1:SUM+PREVGROUPVAL(CDF1:SUM,CLOSE_DATE,1)+PREVGROUPVAL(CDF1:SUM,CLOSE_DATE,2)+PREVGROUPVAL(CDF1:SUM,CLOSE_DATE,3)+PREVGROUPVAL(CDF1:SUM,CLOSE_DATE,4)+PREVGROUPVAL(CDF1:SUM,CLOSE_DATE,5))/(RowCount+PREVGROUPVAL(RowCount,CLOSE_DATE,1)+PREVGROUPVAL(RowCount,CLOSE_DATE,2)+PREVGROUPVAL(RowCount,CLOSE_DATE,3)+PREVGROUPVAL(RowCount,CLOSE_DATE,4)+PREVGROUPVAL(RowCount,CLOSE_DATE,5)) 

 

CDF1 is this row-level formula that counts the number of won opportunities: IF(ISPICKVAL(STAGE_NAME,"Closed Won"),1,0) 

 

On the report, I'm able to create a line graph that has a line for each grouping (picture attached) but then when I try to replicate the same graph on a dashboard, I receive an error (second picture). I'm confused as to why I can't create the same graph on the dashboard as I have it on the report.  

 

Any help would be greatly appreciated!! 

Grouped line chart working on report but not dashboard

 

 

 

Screenshot 2025-05-28 171750.jpg

 

 

  

 

#Reports & Dashboards

13 件の回答
  1. 2025年5月29日 20:22

    For some background, I've used this formula before in a dashboard graph but have never tried to use a grouping with it and plot both at the same time.  

     

    The picture attached is from a dashboard component. The 2 lines are 2 different summary formulas - calculating the rolling 6 month average by count vs amount.  

    For some background, I've used this formula before in a dashboard graph but have never tried to use a grouping with it and plot both at the same time.

     

     

0/9000