Can we change Legend name in cards for YOY views and normal views ?

Kumar619
Kumar619 Member
in Charting
legend name.PNG

Can we change Legend name in cards for YOY views and normal views ?

Answers

  • jaeW_at_Onyx
    jaeW_at_Onyx Coach

    @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.

    https://www.youtube.com/watch?v=CDKNOmKClms&t=406s

    Jae Wilson
    Check out my πŸŽ₯ Domo Training YouTube Channel πŸ‘¨β€πŸ’»

    **Say "Thanks" by clicking the ❀️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • Kumar619
    Kumar619 Member

    @jaeW_at_Onyx

    🟣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.

  • jaeW_at_Onyx
    jaeW_at_Onyx Coach

    @Kumar619 , you are correct, you cannot rename values in the Legend.

    However, you can create beast modes where you change the series name.

    Jae Wilson
    Check out my πŸŽ₯ Domo Training YouTube Channel πŸ‘¨β€πŸ’»

    **Say "Thanks" by clicking the ❀️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • Kumar619
    Kumar619 Member

    @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.

    YOY_issue.PNG


  • Kumar619
    Kumar619 Member

    @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.

    YOY_issue.PNG


  • jaeW_at_Onyx
    jaeW_at_Onyx Coach

    @Kumar619 ,

    another alternative is to construct a CASE statement

    case

when date >=currentdate() - 365 then 'this year'

when date >= currentdate()- 720 then 'two years ago'
...
end


    Jae Wilson
    Check out my πŸŽ₯ Domo Training YouTube Channel πŸ‘¨β€πŸ’»

    **Say "Thanks" by clicking the ❀️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • GrantSmith
    GrantSmith Coach

    Because of leap years and not every year being 365 days I'd recommend using a 1 year or 2 year interval instead.


    case

when date >=currentdate() - interval '1' year then 'this year'

when date >= currentdate()- interval '2' year then 'two years ago'
...
end


    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Categories