Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
So, I have a dataset with multiple hierarchies (I only provide 3 below as an example but it's more). I want to be able to create a timeseries where if you select something from a Tier it shows all the Children in the Legend or a line for each one and averages the values for those children.
So, the x-axis are the dates and the y axis is the average of the values but I can't get the Legend to dynamically shift down to the children relating to that hierarchy. I feel like it somehow combines parameters but just can't seem to get the last bit. I don't want the user to have to select Tier1 or Tier2 but instead because they filtered down to an entity in Tier1 it shows only the related entities in Tier2 in the legend and thus a line for each one; repeat for each hierarchy. When no hierarchy is selected it should show a line for each distinct Tier1 entity.
Tier1 | Tier2 | Tier3 | 1/1/2023 | 1/2/2023 | 1/3/2023 | 1/4/2023 | 1/5/2023 | 1/6/2023 | 1/7/2023 | 1/8/2023 |
TOPA | MIDA | BOT1 | 5 | 40 | 36 | 42 | 8 | 36 | 18 | 16 |
TOPA | MIDA | BOT2 | 47 | 5 | 26 | 23 | 29 | 9 | 1 | 19 |
TOPA | MIDA | BOT3 | 14 | 19 | 18 | 9 | 27 | 29 | 35 | 22 |
TOPA | MIDB | BOT1 | 33 | 0 | 27 | 23 | 29 | 20 | 23 | 8 |
TOPA | MIDB | BOT2 | 31 | 24 | 26 | 12 | 32 | 18 | 2 | 14 |
TOPA | MIDB | BOT3 | 18 | 10 | 36 | 41 | 20 | 22 | 35 | 29 |
TOPB | MIDA | BOT1 | 47 | 25 | 6 | 44 | 48 | 42 | 43 | 43 |
TOPB | MIDA | BOTA | 21 | 15 | 49 | 11 | 20 | 37 | 28 | 10 |
TOPB | MIDC | BOTD | 8 | 25 | 4 | 29 | 8 | 39 | 2 | 29 |
TOPB | MIDC | BOTB | 14 | 16 | 38 | 15 | 41 | 43 | 28 | 32 |
TOPB | MIDB | BOT2 | 25 | 14 | 27 | 48 | 28 | 7 | 39 | 29 |
TOPB | MIDB | BOT5 | 48 | 50 | 39 | 11 | 32 | 10 | 19 | 47 |
TOPB | MIDB | BOT7 | 6 | 3 | 50 | 36 | 4 | 36 | 7 | 49 |
TOPC | MIDD | BOTT | 15 | 42 | 27 | 34 | 1 | 13 | 36 | 42 |
TOPC | MIDD | BOTO | 11 | 40 | 10 | 41 | 33 | 4 | 33 | 14 |
TOPC | MIDD | BOTP | 3 | 23 | 33 | 32 | 10 | 44 | 40 | 13 |
TOPC | MIDD | BOT3 | 18 | 9 | 34 | 29 | 6 | 39 | 41 | 0 |
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |