Using Expression on Gauge Chart

[Anonymous]

Kindly assist me with the gauge chart.

I am trying to get the total count for items from the date I would select along with the previous years and months on the database.

for example:

this is my database.

Date                                     Items

01/01/2013                             50

01/02/2013                             40

04/12/2014                             90

05/02/2015                             85

selecting 04/12/2014, the gauge chart calculates the total Items for 04/12/2014  + 01/02/2013 + 01/01/2013  =   180

gauge chart - Gauge Chart - Expression/Dimension

[#2]

Hi Mohammed,

Please find attched QVW. It may helps you.

Thanks,

Chiru

[Anonymous]

Thanks a lot for help

[Anonymous]

Hi,

Try:

RangeSum(Above(Sum(Item),0,3))