question

Radu S. avatar image
Radu S. asked ·

Change all report filters in one go

Hi

I have several charts and tables in one dashboard. They all have one common dimension filter.

Is there a way of editing this filter in one of the sections, and have the rest of them pick it up? So either a change filter once and apply everywhere, or have all other sections listen for a particular filter change (similar to publishing actions).

Thanks

Radu

nam servernam
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Sebastian K. avatar image
Sebastian K. answered ·

12.4.10 comes with "Filtering bar" plugin. If you put it in your report you will be able to select one or more values for selected dimension in your report. It's different than form, but might be even more useful depending on your use case.

1 comment Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Thanks, Sebastian! That's even better!

0 Likes 0 · ·
Matthew E. avatar image
Matthew E. answered ·

Radu,

In your report select the 'display form' option and it will display the dimensions. If you filter from the form it will apply that to all sections within that report.

Let me know if you have any questions and I can post some screenshots if you need.

6 comments Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Cheers for that Matt - does what I want.

Is there any possibility of displaying the form on the actual report?

Or is there a way of the user updating the filter/form from within the report rather than having to go back?

0 Likes 0 · ·

Hi Radu,

if you save the report with the form displayed it will be prompted every time you access the report.

Hope that helps.

Ciao, Raff

0 Likes 0 · ·

Hi Raff,

Yes, but once a selection has been made you always have to go back to get the form displayed again in case you want to change the selection.

I was wondering if there is an alternative that allows you to change the value without going back.

0 Likes 0 · ·

Hi Radu,

You can add a section or report tab to link back to the same report. This way you can click on the tab and it will reload the report and take you back to the original form.

2 Likes 2 · ·

Good one, Cosmin! :-)

0 Likes 0 · ·

Nice one. That's exactly what I need! Thanks

0 Likes 0 · ·
Brett B. avatar image
Brett B. answered ·

Hey Radu,

Matt, Cosmin, and Sebastian have all provided viable answers. What I do in this situation is add a table section somewhere on the DMI and show only one Dimension type, which you'd want to filter on, (Client Site, IP Address, Software Service, Application, etc) and no Metric. Then, I use publishing actions to have it push my mouse-clicked selection as a filter to the other sections.

In my screenshot, the graph on the right uses Application as a filter and the graph updates for any application I select in the table.


5 comments Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

This is a good answer as well. And the user has all options listed and it's all in the same view.

I like it.

0 Likes 0 · ·

Actually, this is what the filtering bar does, with improved UI/UX and multiselection :)

1 Like 1 · ·

Cool, I'm excited to see it :)

0 Likes 0 · ·

Sebastian, unfortunately I'm stuck on 12.3, so I don't have a filtering bar.

0 Likes 0 · ·

Too bad. Than I would do as Brett suggested.When you upgrade to 12.4.10+ you will just change section type and that's it, because everything else will be ready. One thing to remember though: filtering bar does not allow to define drilldown links as any click on dimension name invokes "apply filter" action immediatelly.

0 Likes 0 · ·
Harshal P. avatar image
Harshal P. answered ·

For all those interested, I have attached a MS Word doc illustrating how the Filtering bar is used. I would like to know how others are using it as well.


Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.