Show Target Line on Bar Chart

[pkelly]

Hi All...

I have a Bar Chart which shows the number of Credit Issue created each month...

Dimension is Month Year...

COUNT(DISTINCT IF(cad_HistoricalMonthNumber >=1 AND cad_HistoricalMonthNumber <= 15, %IssueKeyHeader))

What I want to do is add a line to the chart showing, for want of a better phrase,  a "Target" line...

This line will be equal to 10% below the last 15 months average of issues keyed...

I cannot do this via a script as I want this value to change dynamically if someone applies a filter...

Any ides on how I can do this?

Thanks

Paul

[whiteline · Accepted solution]

Hi.

You could use combo chart and add the target line as another expression with Line representation.

To make this line constant for each months use total in count().

Add:

Another way is to use reference lines on presentation tab.

[pkelly]

Thanks - used the count total route...