how to show reports in dashboard on weekly basis

[poornima batchu]

Hi everyone, 

I have created a report by giving a condition Created relative After 100 days Ago . My requirement is to show cases created on last 100 days from the current date, I used the standard calendar per week. If I run the report today it is giving 121  from first bar but If I run the report tommorow the count of the first bar is changing but in the dashboard it is showing the dates from 14-02 but in report it is giving cases created on 17-02-2022. so the number is keep on changing if I run the report day after tomorrow.

    My requirement is to show the report with constant value untill the entire week removes. I have to show the cases created last 2 or 3 weeks from current date as there is no option to put condition in weeks.so I applied condition using days.

   

[Community Alums]

Hello,

Could you please share configuration and filter condition details.

Thanks.

[poornima batchu]

[Community Alums]

Hello Poornima,

Since relative operator is being used, day changes it will update the data even trend is weekly.

I guess you need to use another operator (on/after/before) or this can be achieved by performance Analytics.

Regards,

Akshay