Get Free Trial

Conditional fotmats

Carlos Puentes asked on April 20, 2018

Please, I have 2 conditional formats into the report configuration, but when I run de component it does not  work.


3 answers

Dmytro Zvazhii Dmytro Zvazhii Flexmonster April 23, 2018

Hello Carlos,
Thank you for your question. Please note, that when you press Save the configuration will be saved to the JSON file. After the page refresh, the browser loads the same configuration you have declared on the web page. If you need to have the configuration from the saved report.json file as a default then you need to change the code and refer your pivot component to the report.json file. 
Please let us know if the information above was helpful for you.

Carlos Puentes April 23, 2018

Dmytro, thanks but I have 2 issues:
1-The option SAVE,to which you refer.
2-I configure the changes in the report.json, but do not take them. It are “conditions”, please to see the attached file.
Carlos Puentes


Tanya Gryshko Tanya Gryshko Flexmonster April 25, 2018

Hello, Carlos,
Thanks for your reply.
We have checked Calificaciones.json and want to share some comments.
It seems that conditions are not defined correctly in this report file.

"Color": "#FF0000"

should be replaced with

"color": "#FF0000"


"formula": "#value >= 3.5 AND #value < 4.5 " 

should be replaced with

"formula": "AND(#value > 3.5, #value < 4.5)"

To configure conditions correctly, we suggest using the UI: click Format -> Conditional formatting and add conditional rules here.
As about the Save option, could you please describe which issues do you experience with this option?
The normal flow should be the following:
1) You configure your conditional rules via UI
2) You save your current report by clicking Save button in Toolbar, after that report.json is saved to your local file system
3) To open this report you use Open -> Local report, and select the report manually
Is any of these steps not working as expected?

Please login or Register to Submit Answer