We are using Einstein Analytics to create more insight on products our customers have, this requires creation of Einstein Analytics dataflows, datasets, dashboards and apps.
We have a use case to help our users understand profitability/loss at first sight. In order to achieve this goal, we created a dataflow to collect the data on project daily. This project includes data such as exchange rate of the day, price of the product, volume of sales and revenue and a date.
The dataflow we created stores the data in a table and extends the table by adding new rows, daily. We aim to store 365 snapshots, so the last 365 days. Currently we can use the analytics dashboards to display the snapshot details side by side.
We are seeking answers for which path to follow. (1) What would be the best practise to show such a change using Einstein Analytics? Using what type of charts with what kind of customisations? (2) Would it make sense to calculate the difference using the dataflow and store them on the table?
Using the compare table I managed to create the logic to have two different revenue sums and the difference in between as change.
However now I fall into an another problem. In the dataset, I have an extra field called 'Snapshot Date in Text' to enable the user pick multiple dates for comparison within dashboard. However in this use case, I need two fields for selections of 'Snapshot Date' as 'Select Snapshot #1' and 'Select Snapshot #2'.
As expected the filters are overriding each other, so I can't really associate the 'Select Snapshot #1' selection with 'Sum of Revenue Snapshot #1' and 'Select Snapshot #2' selection with 'Sum of Revenue Snapshot #2'.
To fix this, I thought about creating another dataset and combine them using SAQL statements. However I fall into an another issue.
The C field is not correctly calculated since I can make to values in the same row. Any ideas how to fix any of the issues above?