Can we change Legend name in cards for YOY views and normal views ?
@Kumar not as far as i know.
Using an offset date calendar like in this video, will give you a scalable way to do this outside of Period-Over-Period cards AND give you control over your legend.
🟣Thanks a lot for reply ! What I can see is it helps in grouping date records and analysing perfectly but renaming the legend is still it wont help.
@Kumar619 , you are correct, you cannot rename values in the Legend.
However, you can create beast modes where you change the series name.
@jaeW_at_Onyx , I am trying Period over Period -Grouped Bar chart and one needs to give continuous dates in X axis and there is no series field so i am unable to achieve what i want.
another alternative is to construct a CASE statement
when date >=currentdate() - 365 then 'this year'
when date >= currentdate()- 720 then 'two years ago'
Because of leap years and not every year being 365 days I'd recommend using a 1 year or 2 year interval instead.
when date >=currentdate() - interval '1' year then 'this year'
when date >= currentdate()- interval '2' year then 'two years ago'