Hi All,
I need to visualize (table) two keyfigures and their change over time, based on one Dimension.
This is These Points were you see a Change in a line Chart for example.
I tried to solve it with previous() and peek() in the script, with before(), above() to query the values from the date loaded before... but could not manage to get it running. Data should always be compared to the previous date loaded.
data is available always for today and today-1 (to -4) weeks.
Data example:
Dimension1 | Date | Value1 | Value2 |
---|
A | 27.08.2016 | 30 | 20 |
A | 03.09.2016 | 30 | 20 |
A | 10.09.2016 | 40 | 10 |
A | 17.09.2016 | 40 | 20 |
B | 27.08.2016 | 10 | 10 |
B | 10.09.2016 | 20 | 30 |
B | 17.09.2016 | 20 | 30 |
The result should show e.g. that keyfigure "Value1" for Dimension "A" changed from 30 on 03.09. to 40 on 10.09.
possible Result:
Dimension1 | Keyfigure | ChangeFromDate | ChangeFrom | ChangeToDate | ChangeTo |
---|
A | Value1 | 03.09.2016 | 30 | 10.09.2016 | 20 |
A | Value2 | 03.09.2016 | 40 | 10.09.2016 | 10 |
A | Value2 | 10.09.2016 | 10 | 17.09.2016 | 20 |
B | Value1 | 27.08.2016 | 10 | 10.09.2016 | 20 |
B | Value2 | 27.08.2016 | 10 | 10.09.2016 | 30 |
any help appreciated!