Last ----

[#1]

Hi to all!

I have a chart and my dimension is time(minute) and the expression is count of each minute...I would like to show the last 10 minutes customer count....however, I havent edited time dimension for last 10 minutes...how can I do it?   I have attached a sample data set

Thanks for help me out.

[MK_QSL]

=COUNT({<Minute = {'<=10:00'}>}Location)

or

=SUM({<Minute = {'<=10:00'}>}Count)

or

=COUNT({<Minute = {'<=10:00'}>}Count)

[er_mohit]

Simply write this on expression side

Count(TOTAL if(Minute<='10:00',Count))