Hello,
I have created a stacked Waterfall chart with 2 dimensions (as below).
In the chart, the Dim2 will be grouped under Dim1. The Dim2 consists of 10 values relating to 10 different metrics.
1 expression is used (Used pick, Match function to map 10 different formulas to values in Dim2).
So, the Dim1 - A and B will have a single Bar, C will have stacked chart with C1 and C2 (2 metrics), D will have stacked chart with D1,D2,D3,D4,D5,D6 (6 metrics). PFA image for reference.
I am facing issue with the position of 'C' (Dim1) only during some random selections made in the year, quarter, month and week filter. (this bar doesn't align to the axis value and moves above value of A).
Eg. even if value of offset is 6000, it is in position of 10000.
Bar Offset- The formula of A1-B1-C1-C2. This offset has been set to C2.
The position of other bars are as expected during any selections.
Requesting your help on this issue.
| Dim1 | Dim2 |
| A | A1 |
| B | B1 |
| C | C1 |
| C | C2 |
| D | D1 |
| D | D2 |
| D | D3 |
| D | D4 |
| D | D5 |
| D | D6 |
