asked on April 2, 2024
I want the value dropdown in the conditional formatting to show all the column names from the report configured but this should not add extra columns in the table in viewer. How can I do this ?
i.e, what I understood is ∑values is used in two places 1.to configure the table columns in the viewer and 2. The values dropdown in the conditional formatting. But I want these both to be different. I want to add all the column names from the report data into the dropdown in the 2nd case, so I can apply conditional formatting to the table using the columns which are not configured in the table but present in the report data.
⋅ April 2, 2024
Hello, Sai!
Thank you for contacting us.
Kindly note that from the UI, it is only possible to apply conditional formatting to the values present in the current slice. However, it is possible to create more complicated conditions from the code using our addCondition() API call: https://www.flexmonster.com/api/addcondition/.
For the described case, our team recommends creating your own UI controls and using our API calls to create formulas with values not present in the current slice.
We have prepared a JSFiddle sample to illustrate the idea: https://jsfiddle.net/flexmonster/sp2nw6m4/.
Please note that you can apply only count and distinct count aggregations to string fields.
You can find more details about conditions in our docs: https://www.flexmonster.com/api/conditional-format-object/.
Hope you will find our answer helpful.
Please let us know if the suggested approach works for your case.
Kind regards,
Solomiia
⋅ April 9, 2024
Hello, Sai!
Hope you are doing well.
Our team is wondering if the suggested approach of using addCondition() API call along with custom UI controls works for your case.
Looking forward to hearing from you.
Kind regards,
Solomiia
⋅ April 16, 2024
Hello, Sai!
Hope you are having a great week.
Just checking in to ask if the suggested approach of using addCondition() API call along with custom UI controls works well for you.
Looking forward to hearing from you.
Kind regards,
Solimiia
⋅ April 28, 2024
Hi Solomiia,
I have checked the solution you have provided at first it looked like it will work, but the JS Fiddle sample you have attached itself is not working. I mean when I changed the field to count/distinct count and applied it to the color (string field). The chart is not reflecting the conditions which I have applied.
Can you check that again please 🙂
⋅ April 29, 2024
Hello, Sai!
Thank you for getting back to us.
Kindly note that to apply conditional formatting to the measures that are not present in the slice, you should use the full measure name, e.g., count("Color") instead of #value in the formula.
I have updated the example to illustrate the idea☺️: https://jsfiddle.net/flexmonster/0t46sbod/
Please let us know if everything works well now.
Kind regards,
Solomiia
⋅ April 29, 2024
Hi Solomiia,
thanks for replying with the updated answer. I have gone through the solution and we feel confident to implement the solution provided.
kind regards,
Sai sumanth.
⋅ April 30, 2024
Hello, Sai!
Thank you for your feedback.
We are glad to hear the suggested solution works well for you.
Feel free to reach out to us in case of any other questions.
Kind regards,
Solomiia
