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'
It looks like you're new here. Those who sign in get access to engage with even MORE fire content. To get involved, click one of these buttons!