Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Sep 29, 2020, 1:32 PM

Creating a constant diagonal line starting from 0 and ending at 14 million

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 answers
  1. Robert Breen
    Sep 29, 2020, 1:45 PM

    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​ 

    Book2_v10.5.twbx
Write an answer...
0/9000