Returning data of Friday on Monday

[Anonymous]

Hi Guys,

every morning I want to show my colleagues the sales of yesterday.

We're not open in the weekend, so on Monday I want to show the sales of the previous Friday.

Should I script this in my calendar? And if yes, what is the best way to do this?

Attached you'll find the script of my calendar.

Thanks in advance!

Cheers,

Mike

[vinieme12 · Accepted solution]

You should be modifying the expression like below

example

=if(num(WeekDay(Today()))= 0   /// Checking if today is Monday

, sum({<SalesDate = {"$(=DATE(Today()-3,'YOURDATEFORMAT'))"} >}Sales)   // Sales for Previous Friday

,else_your_existing_expression )

[shubham_singh]

First load your data in App.

Sales:

LOAD * FROM SalesData.qvd;

//Then calculate maximum date of your data.

MaxDate:

LOAD max(Date) as MaximumDate

Resident Sales;

LET varMaxDate = num(peek('MaximumDate',0,'MaxDate'));

This should solv your problem.

[Anonymous]

That worked perfectly in the expression of my chart, awesome!

Thanks a lot Vineeth

[Anonymous]

I persume I'll have to do this in my calendar script in my loading script Shubham?:)

[shubham_singh]

Yes