I’m trying to replicate an Excel chart (example screenshot below) in Dundas but having trouble showing it on one chart as required and I am not sure what I am doing wrong. I want to show how many items, by week YTD cumulative, that we have Booked, Shipped, and Installed as three separate lines on one chart. I’m able to show each on a separate chart perfectly, but that’s not what is needed.
The Shipped & Installed date and count come from the same table in SQL Server originally and currently in the same Data Cube, with Booked coming from a different SFDC table in SQL Server and currently in a separate Data Cube.
Where I am having trouble: I created a Metric Set with a Cumulative Total formula for the count showing YTD by week (Time Dimension) as a line for Shipped and it’s perfect, but then when I try to add the Cumulative Total count for Installed to the data analysis panel I only get an exact copy of the Shipped Line. I believe it’s because the Time Dimension for Shipped is causing only Shipped records to display, but if I try to add a time dimension for Installed to the data analysis panel it either scrambles everything or loads forever.
Any ideas what I am doing wrong? Appreciate any help.
Trying to replicate this:
