Filter Data on Report

  • Profile Image
    h.grasshoff
    Asked on October 17, 2013 at 10:09 PM

    Hello, we want to filter Date in different reports. Example: There is a dropdown in our fprm, were our client can choose kind of his problem: Bug, Change request, Idea

    Now we want to show one report were all entries are listet, an one only with the entries with "bug" choosen.

    Is that possible? How to?



    This is a re-post of a comment on How to Create a Visual Report with Your Form Submissions

  • Profile Image
    Cesar
    Answered on October 17, 2013 at 11:47 PM

    Hello, 

    Unfortunately it is only possible to sort the data on the reports. To filter the data you can use an external spreadsheet application such as Microsoft Excel

    To export the data to excel, you can do the following:

     

    Select the form you are working on, then click on the submission button at the top of the toolbar.

    https://cms.jotform.com/uploads/image_upload/image_uploadglobal/19402_export2excel.jpg

    Then click the Excel Icon on the bottom left corner of the displayed submission. 

    https://cms.jotform.com/uploads/image_upload/image_upload/global/19403_export2excel2.jpg

     

    If you do need further support, do let us know. Thank you.