Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.