Same date throughout all years available

[ioannagr]

Hey all,

I want to examine a trend in a line chart where i can see the same date over the years,

say 14/11/2019, 14/11/2018, 14/11/2017 etc

Let's say this date is according to today().

Any ideas?

[sunny_talwar]

May be use setdateyear() function within your set analysis to get the year you want to look at.

[ioannagr]

I'm sorry, I don't quite understand what I should do.

I thought about creating a dimension like this one 

If( date=max(date), ' max date', If( date=max(date)-365,'same date last year', If(date=max(date)-2*365, 'same date 2 years ago, 'null)))

but I'm not quite sure...

What do you say?

[sunny_talwar]

Would it be possible to share some sample data and explain what exactly you are looking to get from it?

[mahaveerbiraj]

HI ,

Use year(Date) as  NewColumn   in the script  function to u will get only year from the date column  ,

Then you can see trend year  wise in line chart