Can I let my users access the filters on a visual report like using Pivot tables on Excel?

While I can implement filters to show subsets of the results from all the submissions, I'd like to offer them as buttons on the visual report.

Example: 100 forms, tracking eye color and college level

Filter college level for eye color = green

Filter college level for eye color = blue

Filter college level for eye color = brown.

I'd like to use a drop down or a set of buttons that invokes the filter and redraws the screen

Or, how can I apply a filter for just one of the charts?

Thanks?

Unfortunately, you can only use the Visual Report editor within the Form Builder.

When the Visual Report of the form is publish, there is no editor available to make them behave like pivot table.

An alternative option you may want to check is by using the Reports To Cloud App.

What it does is send an Excel Report on your Dropbox account. You can create the Pivot table using the Excel Report as the data source.. then publish/share the Chart/pivot table report to your end users.

Hope this helps. Let us know your feedback on this.