Buttons and chart

[mohan2391]

Hi,

I have a field with values Direct & Indirect.

Now I need to create a chart that shows all the data by default.

I need to show 2 buttons 1 for Direct 1 for Indirect, when click on the buttons the corresponding data should show.

How to create the buttons and how to make the combined data chart as default..

Please explain me in clear as i am new here.

[mohammadkhatimi]

Can u share sample data which is easy to rply ur answer..

[sorrakis01 · Accepted solution]

Hi,

You can create a trigger on button option or use a variable.

look the Example with trigger

Regards

[mohan2391]

Hi Jordi,

That's fine.

And by default it needs to show the sum of those 2 means direct data + indirect data..

How it will be done

[rajpreeths]

Hi,

You can make use of triggers.

1) First create a On open trigger to clear a field which has Direct and Indirect Values.

2)Create two buttons named Direct and Indirect buttons.

3)Create SELECT IN FIELD triggers for that two buttons.

[mohammadkhatimi]

Clear all selection it will work as by default value means Addition of Direct and Indirect..

[rajpreeths]

Go to button properties and add actions as mentioned in the below inline images

[sorrakis01]

Hi,

When you open the app you don't have selected any field. If you have selected a field you need to clear it. Another option is create a sheet trigger for clear all selections when open the seheet.

regards

[mohan2391]

Oh,

Yes, Thank you Mohammad & Jordi for your support..

[trdandamudi]

If you want to avoid triggers then may be this.... Click on the drop down (As circled in the image) to select Direct and In-Direct: