Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Bit of a weird situation. I created a master dimension based on a nested If statement and it was working as intended.
It still shows up in the table and most of the charts, but when I click on it to add it as a filter, it does not show up as a single filter like it did yesterday. Rather, it shows up as all the component parts.
The master dimension code is essentially:
= if((Var1 = X or Var1=Y) AND (Var2 = A) AND (VarN = B), 'Value A', 'Value B')
Previously, when I would select the Filter A option, it would show up in the filter Selections in one value. I don't think I changed anything with the code, but now when I select it, it shows up as multiple selections (Var 1, Var2, VarN, etc.).
Have others seen this happen?
Another post suggested creating the dimension in the load script and not as a master dimension. This solved the issue that I was having.
Another post suggested creating the dimension in the load script and not as a master dimension. This solved the issue that I was having.