Overall sales based on timestamp

Mon, 22 Feb 2016 04:48:02 GMT

Hi Viewers,

Good morning!

I need a clarification,

Sum({<year={2015},month={'May'},day={'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.

Re: Overall sales based on timestamp

swuehl — Mon, 22 Feb 2016 09:45:18 GMT

You can create fields for hour, minute, second from a timestamp field just like you can create day, month, week, year, etc. from a date:

Set TimestampFormat = 'MM/DD/YYYY hh:mm TT'; // Adjust to your timestamp format code!

LOAD

TimeStampField,

Hour(TimeStampField) AS Hour, // will return value between 0 and 23

Minute(TimeStampField) AS Minute, // will return value between 0 and 59

WeekDay(TimeStampField) as WeekDay,

....

FROM ....;

Then in your set expression:

=Sum({<Hour = {18}, WeekDay = {'Sun'} >} sales)