CY vs PY and Multiline Chart
Hi All,
I am trying to build a multiline chart that would have 2 Y-axis line chart.
Y1 Axis to show Cumulative Line of YTD Sales vs PY to Date Sales and
Y2 Axis to show YTD Average Sales vs PY to Date average sales.
I have tried all the available line charts and seems not to be the one as per the picture attached.
Also, what's the best approach to calculate previous year to date in DOMO. Watched the brilliant video by @jaeW_at_Onyx on YouTube and seems a little confusing. Could some help please with some direction?
Best Answer
-
For previous year to date, I do:
"Case when Date >= DATE_SUB(CurrentDate, interval 1 year) and Year(Date) = Year(DATE_SUB(CurrentDate, interval 1 year) ) then Value End"
Find the year value of today's date 1 year ago and only selects dates less than or equal to today 1 year ago.
0
Answers
-
For previous year to date, I do:
"Case when Date >= DATE_SUB(CurrentDate, interval 1 year) and Year(Date) = Year(DATE_SUB(CurrentDate, interval 1 year) ) then Value End"
Find the year value of today's date 1 year ago and only selects dates less than or equal to today 1 year ago.
0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 304 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 105 SQL DataFlows
- 644 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 772 Beast Mode
- 74 App Studio
- 43 Variables
- 726 Automate
- 185 Apps
- 466 APIs & Domo Developer
- 61 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 402 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 9 Software Integrations
- 135 Manage
- 132 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive