I have two expressions
Coverage % current reporting period
Coverage % previous reporting period
I need to show in a column in my pivot chart :- a linear gauge with segment 1 showing the result of Coverage % previous reporting period, and segment 2 showing Coverage % current reporting period minus Coverage % previous reporting period. The difference will always be positive.
This is currently achieved through an excel file using the series function.
=SERIES(,dash_boards!$M$7:$M$33,dash_boards!$R$7:$R$33,1)
Any help will be greatly appreciated