What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

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

    Asked by DougMarlowe on August 25, 2015 at 08:07 PM

    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?

     

     

    visual report excel filters visual pivot
  • Profile Image
    JotForm Support

    (Private)

    Answered by jonathan on August 25, 2015 at 09:48 PM

    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.