Skip to main content
Topics#Reports & DashboardsDavid Ashton's Question
David Ashton (Claranet Ltd) asked in #Reports & Dashboards
Jan 19, 2021, 11:13 AM

How do I show a cumulative reference line on a line chart? It seems like the only option is a flat line.

Hi All

 

I would like to show cumulative performance overtime measured against a plotted reference line. The only problem is that the reference line field seems to work with a fixed number and then flat-lines the reference line across the chart at the fixed level rather than cumulative over the time period.

 

I wondered if the cell accepted a formula for a straight line like the old y=mx+c equation from school days.

 

Regards

 

 

Dave

1 answer
  1. Michael Brown (SETGO Partners) Forum Ambassador
    Jan 19, 2021, 9:19 PM
    Hi David, 

     

    Unfortunately the plotted reference line cannot be a formula or dynamic value. That is a current limitation of line charts, where the reference must always be a static number. Unfortunately, I'm not aware of other work arounds at this time other than to use a more powerful reporting tool such as Einstein Analytics.

     

    Thanks,

     

    Mikey
Write an answer...
0/9000