Skip to main content
Lila Ross 님이 #Reports & Dashboards에 질문했습니다

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일 오후 8: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