Filter interaction and update button

I am following these pages to create a filter interaction:

It all works nicely together. The only thing is that I have an update button, but the filter interaction skips it. If I click on my checkbox, the data is updated straight away. Is there a way to have the update button handle the filter interaction as well?

Hi Guillaume,

Using the checkbox list with the update button seems to work for me. Did you make sure that you connected to the update button to the filter control?

ezgif-2-8a65f9ba9a58

Hi Guillaume,

Filter interactions can be set up on anything (including a plain button or even a rectangle) and are separate from using a filter control as an actual filter. The update button applies to a filter’s regular behavior that just involves connecting the filter to a parameter - it delays the updating of that parameter until the user clicks the update button. Interactions are always set up on a particular event, and will happen at whatever specific time that event occurs, which is probably Value Changed in this case on that checkbox list filter. (You’ll probably want to set up multiple filter actions on Value Changed each with Bound Visual set to a particular item if you haven’t already.)

If you wanted to wait until the user clicked a button before passing a value somewhere through an interaction, it’s possible to disconnect the view parameter that’s being set by the checkbox list from the visualization in the Parameters window, add a separate view parameter that’s connected to the visualization, and set up an interaction on a regular button to pass a value from the checkbox list view parameter to the visualization’s view parameter.

It’s possible we could be more helpful for your scenario if you could describe more what you were trying to do overall.

Thanks for your help.

What I am trying to do is as follow:

  • I have a (live) data cube with a few parameters
  • I want to set all those parameters before firing a request (to not send multiple not needed queries to the DB)
  • One of those parameters is a radio button list (or checkbox list - I don’t mind which one as long as it works :slight_smile: ).

This is in short how the ‘header’ of my dashboard looks like:

The date filter is not an issue. The radio button list I cannot get handled by the button (I did manage to directly update the filter in the datacube).

If I can, Id’ rather use the radio button component (display controls are better for my use case - I can get all of them horizontal).

I think I get what you said and still need to test it regarding the solution to have delayed filter, but my concern (before testing) is that I am not sure if the update button and click action would act at the same time, or if it would still trigger 2 queries. I’ll dig deeper tomorrow.

Hi Jeff,

How did you connect the update button to the filter control? Can you please elaborate on this.

Thank you.

HI Sarah,

There isn’t much to it. Just add the update button from the filter options in the toolbar and you’ll see a popup which allows you to check off the filters on your dashboard that are tied to the update button.

image

Thank you Jeff. I figured this after reading your past message and then searching on Dundas support. I was using simple button object before and not the filter “Update button” so was not sure how it worked but its working now.

Thank you again.