Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I have 4 cities A,B,C,D in the dimension.
CITY | PRODUCTION |
A | 1000 |
B | 2000 |
C | 1000 |
D | 2000 |
I need to filter on A,B through calculated dimension. How can use the following functions.
1. =
2. <>
3. Like
4. Not Like
Ashok
NOT inputing the expression in the statement.
Dear Shoham,
Once I made it calculated dimension the data filters. Thank you so much.
Glad to help.
What I would recommend in this case is to create a filtered dimension in your script (with the same syntax) and then use it as a chart dimension. It's "healthier" than using a calculated dimension in charts and should also be quicker / less resource intensive.