Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Returning data of Friday on Monday

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

1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

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 )

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

5 Replies
vinieme12
Champion III
Champion III

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 )

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
shubham_singh
Partner - Creator II
Partner - Creator II

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
Not applicable
Author

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

Thanks a lot Vineeth

Anonymous
Not applicable
Author

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

shubham_singh
Partner - Creator II
Partner - Creator II

Yes