Is it possible to display a % change from month to month in a bar chart?

[Anonymous]

Bar Chart: That give me monthly totals. Is it possible to show a % change from month to month?

Dimension: ServiceDate_YYYYMM

Expression: Count( {<STARTDATE_YYYY = {"2016"}>} ID)

[sunny_talwar]

May be like this:

Count(ID)/Above(Count(ID))

[pooja_sn]

num((Count(ID)-After(Count(ID)))/After(Count(ID)),'#.##' ) 

Use 'Before/After' as per orientation of your chart

[Anonymous]

When I use the formula you suggest I receive a "No data to display" Would it have to do with how I'm calculating my expression?

Orginial expression = Count( {<STARTDATE_YYYY = {"2016"}>} ID)

[sunny_talwar · Accepted solution]

I think After is not right here. After will only work in pivot table.... Try this:

Num(Count(ID)/Above(Count(ID)) - 1, '#.00%')

[Anonymous]

I see results using your expression but it's not a % change from month to month.