Can we change Legend name in cards for YOY views and normal views ?
Answers
-
@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.
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"0 -
@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.
0 -
@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"0 -
@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.
0 -
@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.
0 -
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"0 -
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!**2
Categories
- 10.6K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 474 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 478 Datasets
- 214 Visualize
- 259 Beast Mode
- 2.1K Charting
- 12 Variables
- 19 Automate
- 356 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 249 Distribute
- 65 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 189 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive