Charting Cumulative data with snapshot data over time in combo chart
Hi - I am looking to chart progress over time of two data sets on the same chart. Using a relatable example, imagine you wanted to plot the number of Movies available on AppleTV, Netflix, and Amazon prime vs the consumption of that content.
Your data gives you a snapshot of the movies available at the end of the week, but your usage data is cumulative giving you the total daily views.
Product
Date
Movies
Apple+
09/11/2020
1000
Netflix
09/11/2020
4889
Amazon Prime
09/11/2020
82299
Apple+
09/04/2020
1888
Netflix
09/04/2020
82992
Amazon Prime
09/04/2020
2888
Apple+
8/28/2020
2899
Netflix
8/28/2020
2347
Amazon Prime
8/28/2020
7992
Product
Date
Usage
Apple+
09/11/2020
1400000
Netflix
09/11/2020
2800000
Amazon Prime
09/11/2020
450000
Apple+
09/10/2020
219900
Netflix
09/10/2020
1899999
Amazon Prime
09/10/2020
178299
How would you plot this in Qliksense to get smooth lines? If the dimension is Date, and measures are sum(Movies) and sum(Usage), how do you plot this so you get smooth lines and ignore the dates where you don't have movie data.