i did not find a solution for my problem so I am writing this text.
Depending on the actual date I want to use time in columns but with different steps. For example today (17th of November) i want to see an average measurement with the following steps
Q1, Q2, Q3, last month, actual month, year, Cw-3, Cw-2, Cw-1, actual Cw.
a different visualisation would be:
01/2018 , 02/2018 , 03/2018 , 04/2018 , 05/2018 , 06/2018 , 07/2018 , 08/2018 , 09/2018 , 12/2018 , 11/2018 , 12/2018, 2018 (Whole Year), Cw-3, Cw-2, Cw-1, actual Cw.
Any idea how to do this?
Thank you for your answers
All the best
Johannes, if you want all those levels of dates in the same view, I think you'd need a series of Calcs.