Need Last 14 days records with same days

[iahmadmca1]

Team,

just I want one help from your side. Please help me to do this one.

Provided the below requirement.

1. In the line chart, we need last 14 days records with same days.

As for example:

If today is Monday then we need last 14 days  Monday records in the line chart.

If today is Tuesday then we need last 14 days Tuesday records in the line chart.

If today is Wednesday then we need last 14 days Wednesday records in the line chart.

Line chart should be one but 14 days records should be dynamic based on todays days. Please let me know in case of any clarifications.

Thanks,

Irshad Ahmad

[sunny_talwar · Accepted solution]

May be like this

{<WeekDay = {"$(=WeekDay(Today())"}, Date = {"$(='>=' & Date(Today() - 98, 'DateFieldFormatHere'))"}>}

[iahmadmca1]

Thanks sunny for the quick response.Let me check and get back to you.

[iahmadmca1]

Sunny sorry for late response.

I checked your expression based on expression the result is showing no data to display.

Please find the below screenshot for your reference.

Thanks,

Irshad Ahmad

[sunny_talwar]

Where is your expression? Sum(Sales)? Sum(Cost), Count(ID)? What calculation are you trying to perform?

[iahmadmca1]

Hi Sunny,

I was missing to add the calculation in your expression.i did little change in your expression and now its working fine.

Thanks for helping me.

Thanks,

Irshad Ahmad