Skip to main content

Hi all,

 

I am trying to create a line that passes through 0 and ends at 14 million.

I am attaching an image, the blue line represents the running total and I want to implement the red straight line.

The X axis is date and Y-axis is Sales.

Any help is appreciatedCreating a constant diagonal line starting from 0 and ending at 14 million, thanks.

5 respuestas
  1. 29 sept 2020, 13:45

    Hello @Rupesh Ghosh​ ,

    Try this calculation

    max(14000000) / (window_count(countd(DATETRUNC('month', [Order Date])))-1) * abs(FIRST())

     

    Hope this helps! See attached.

    @Robert Breen​ 

0/9000