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.
