# Report designer - dynamicaly toggle the pareto

**URL:** <https://forum.inductiveautomation.com/t/report-designer-dynamicaly-toggle-the-pareto/65272>\
**Category:** Ignition\
**Tags:** vision, scripting\
**Created:** [October 17, 2022, 9:51am UTC](https://forum.inductiveautomation.com/t/report-designer-dynamicaly-toggle-the-pareto/65272 "2022-10-17T09:51:33Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![dawid\_styczynski](https://avatars.discourse-cdn.com/v4/letter/d/e495f1/32.png) [@dawid\_styczynski](https://forum.inductiveautomation.com/u/dawid_styczynski)\
**Post date:** [October 17, 2022, 9:51am UTC](https://forum.inductiveautomation.com/t/report-designer-dynamicaly-toggle-the-pareto/65272/1 "2022-10-17T09:51:33Z")

</div>

Hello,  
i came across a requirement that i dont know if it is be possible.  
I could do different reports for this case however i would like to know if there is a way to let the user toggle the pareto option in a category chart.

Cheers !

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [October 17, 2022, 10:44am UTC](https://forum.inductiveautomation.com/t/report-designer-dynamicaly-toggle-the-pareto/65272/2 "2022-10-17T10:44:04Z")

</div>

I would make a script datasource with with both (or modifiable as needed) queries inside the script.

---

<div class="post-metadata">

**Author:** ![dawid\_styczynski](https://avatars.discourse-cdn.com/v4/letter/d/e495f1/32.png) [@dawid\_styczynski](https://forum.inductiveautomation.com/u/dawid_styczynski)\
**Post date:** [October 17, 2022, 11:45am UTC](https://forum.inductiveautomation.com/t/report-designer-dynamicaly-toggle-the-pareto/65272/3 "2022-10-17T11:45:37Z")

</div>

the problem is not the data, i would like to toggle the pareto option in the category chart on and off. (there is a checkbox for that)  
one possible solution would be playing with the visibility ie. if the usser toggles the button i disable the visibility in one report viewer where the pareto is always on and show another where the pareto is always off.  
however i wonder if there is any other way to access the pareto checkbox inside a category chart

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [October 17, 2022, 12:18pm UTC](https://forum.inductiveautomation.com/t/report-designer-dynamicaly-toggle-the-pareto/65272/4 "2022-10-17T12:18:44Z")

</div>

Gotcha. Apologies for misunderstanding your question.

Go to the properties tab of the chart, right-click on 'Pareto', then pick 'Use Dynamic data key'.  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/0/e0cfe5fab4217c061fa8a96ef0401dcb94726aaf.png)