total sales based on timestamp

[#1]

Hi Viewers,

I have a doubt.

Sum({<year={2015},month={'may'},weekday={'sun'}>}sales)

But how do we analyse total sales based on timestamp

Suppose we have timestamp 6:00pm for Sunday

Pls help me on this.

[Chanty4u]

use timestamp as now()

it will give the exaxt time as

[hic · Accepted solution]

If you want a Set Analysis expressions picking out transactions after 6:00pm on Feb 21st, you can use

Sum({$<Timestamp={">=2/21/2016 6:00pm"}>} Sales)

Just make sure to use the correct timestamp format. See Dates in Set Analysis

HIC

[#4]

Thanks Henric for your help.