I have the data that changes over time. I got the task to visualize how many records were changed to higher or lower values than previous period. This should be dynamic so the user can choose any set of dates and the comparison would be shown over time.
Example data
Company
Date
Parameter
Other dimensions/measures
A
2020-01-01
10
...
A
2020-02-01
20
...
A
2020-03-01
20
...
A
2020-04-01
10
...
B
2020-01-01
50
...
B
2020-02-01
50
...
B
2020-03-01
40
...
B
2020-04-01
30
...
Expected result if form of count(Company)
Up/Down
2020-01-01
2020-02-01
2020-03-01
2020-04-01
#Company Up
-
1
-
-
#Company Down
-
-
1
2
If the user narrows down to selected dates (for example Jan and Apr only) I should present:
Up/Down
2020-01-01
2020-04-01
#Company Up
-
-
#Company Down
-
1
By using some complex logic (Pick, Aggr and Sign) I was able to create Master dimension showing Up or Down for single pair of dates but I have no idea how to expand this for any dates. Any hint would be highly appreciated my ideas are depleted.
