I am trying to use multi-period projection on my mult-line chart (Two lines are at different periods in time) to forecast.
X - Axis - 0 - 36 Months in Service
Y- Axis - Warranty Spend (CPU) (Running Total)
Series - 2 different products (A & B)
- Product A has data for 11 months.
- Product B has data for 4 months.
- Project the spend per unit for product A over the Warranty period (3 years)
- Project the spend per unit for product B over the Warranty period (3 years)
Any help would be grateful.
Thanks in advance!
Unfortunately, it doesn't look like you can use the Last Value Projection properties when you have more than 1 series. See KB article:
Note: Though Last Value Projection properties appear in the Chart Properties for Multi-Line graphs, they work only when the graph contains only one series.
Would be worth submitting in the Ideas Exchange to see if Domo can make that work in the future.