How to show data point in weeks or month gap in line chart

Amiran_D — Sun, 03 Oct 2021 06:59:53 GMT

Hi,
I want to create a line chart that shows the last 20 data points in 7 days or month gaps.

for example, If a user selects "Weeks" and the date 29/09/21 in the date picker then the data will show the date: 29/09 ,22/09, 15/09,8/09 ...

if they will select 28/09/21 then:28/09 ,21/09, 14/09,7/09.... and so on...

I found out I can do this if I create a flag in the script for a specific day but I need to be dynamic per the selection

the data points should be dynamic as well so if a user selects the 28/09 it will show 20 weeks back and not from the max date (like an interval window that move per selection)

in the image you can see the result I have now but this is just for a specific date in the script,

the dimension is: FREEZ_DATE and

the set analysis is:

avg({<[Last$(=^Diff)DayFlag]={1},[$(=^DateDiff)]={">=$(=Max([$(=^DateDiff)]-19))<=$(=Max([$(=^DateDiff)]))"},FREEZE_DATE>} SCORE)

topic How to show data point in weeks or month gap in line chart in App Development

How to show data point in weeks or month gap in line chart