Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
use timestamp as now()
it will give the exaxt time as
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
Thanks Henric for your help.