Do not include the last day's data

[#1]

How can I amend my expression so that the last day of the data set is NOT included in the chart?

SUM({$<CalendarDayName-={'Sat','Sun'}>}DaySummary.Users)

[tresesco · Accepted solution]

May be like:

SUM({$<CalendarDate-={"$(=Max(CalendarDate))"}>}DaySummary.Users)

[PrashantSangle]

Hi,

Can you explain with sample data?

Regards

[#4]

hi

try this

if(not wildmatch(CalendarDayName,'Sat','Sun'),DaySummary.Users)

[jyothish8807]

In the below script it will exclude max(date) and will take all the other dates.

SUM({$<CalendarDate-={"$(=Max(CalendarDate))"}>}DaySummary.Users)

Regards

KC

[PrashantSangle]

Hi,

I understand what Tresesco Suggest.

But I am Confused with Alex requirement, Becuase below expression was tried by Alex made me confused

SUM({$<CalendarDayName-={'Sat','Sun'}>}DaySummary.Users)

that what he actually trying to acheive, that either he want data upto last days or He is trying to exclude Week end data.

That why I asked Alex to explain with some example.

But he got correct solution, So I understand what was he is looking for

Regards,

[jyothish8807]

Sorry bro