Set graph to start on specific date

[jp_afc]

I have data that starts from 01/03/2014 but I want my line graph to start from 01/01/2020 to current date, how would I do this?

I want to create a line graph showing number of incidents that occurred each day start from 01/01/2020

[NiTo]

Hi Jp,

Interesting question. I would also like to see the answer for this one. Hope you get a reply soon.

[Zapparoli · Accepted solution]

Hello Jp_afc,

In this case, you have some options.

The first one is working on your measure. You can specify a set Analysis with a data range >= than 01/01/2020 inside your measure, this will make only date greater than 01/01/2020 to appear on your chart.

You can also create a new dimension in the script like:

if(My_Date_Field < 01/01/2020, null(), My_Date_Field) as New_Date_Field.

Personally I would work on my measure instead of going to script on this one.

Hope this helps.

-Zapparoli 

[jp_afc]

Perfect. Thank you for your help using the set analysis method worked.