Kom Son Posted February 16 Share Posted February 16 Hello. I find that I’m unable to filter/limit a bar chart via 2 dropdown property controls for different columns (e.g location and product type). In the limit by expression area, I can only use one expression at a time like: [col1] = “${prop1}” [col1] = “${prop1}” AND [col2] = “${prop2}” does not work or produce any data in the chart. any help would be appreciated! Link to comment Share on other sites More sharing options...
Gaia Paolini Posted February 16 Share Posted February 16 can you share an anonymised sample of the data? It might be that the particular combination of values of [col1] and [col2] does not exist? Link to comment Share on other sites More sharing options...
Kom Son Posted February 19 Author Share Posted February 19 The combination of data exists because it works when testing with filters Link to comment Share on other sites More sharing options...
Gaia Paolini Posted February 20 Share Posted February 20 The functionality works for my test case. How are you setting up prop1 and prop2? Could it be that the values are not exactly the actual values (eg. the actual values have extra spaces) . Are these categorical values? Please provide details. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now