IDEAL_LINE

IDEAL_LINE(0, LAST([Count Of Records]))

Syntax

IDEAL_LINE(start, end)

Shows the line by defined start and end points.

start: Any numerical constant or aggregation created against numerical chart dimension used for the chart.

end: Any numerical constant or aggregation created against numerical chart dimension used for the chart.

Use cases

Ideal Line

Shows the line from zero to total count of records.

Source: History

History records related to production flow of implementing super hero protective suite feature

Start DateEnd DateStatus
03 Jan 2018 0010 Jan 2018In Development
10 Jan 2018 0013 Jan 2018Laboratory Testing
13 Jan 2018 0015 Jan 2018In Development
15 Jan 2018 0018 Jan 2018Battlefield Testing

Chart BAR

X: DAY([Start Date])

Y: RUNNING_SUM(COUNT([Row Number]))

Annotation: IDEAL_LINE(0, LAST([RUNNING_SUM(Count of Records)]))

Chart

DAY(Start Date)RUNNING_SUM(Count of Records)
3 Jan 20181
10 Jan 20182
13 Jan 20183
15 Jan 20184