0 Replies Latest reply: Nov 13, 2013 3:31 AM by celia dyer RSS

    How to show a linear gauge with two expressions

      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