I have a dataset composed of daily availability data for our machines.
I want to achieve a result like this one below:
|Machine ID||Performances on 30th September||Performances on 29th September||Difference|
In the dashboard I am developing there is a filter based on Machine ID like the one in the example above. This filter is fixed with the IDs provided.
What I want to do is create a table that displays daily average availability for each machine on the previous day in one column and the same data in another column but filtering for 2 days before instead.
Moreover, I would like to add a column for the difference of these values.
How Can I achieve such result?
At disposal for further clarifications if needed.