Visual Report builder>> Multiple filters: The multiple filters do not work in the Visual report builder.

  • Profile Image
    SouthernUnitedHC
    Asked on May 25, 2020 at 06:58 PM

    I have an "old" report which has submissions in the last 1 day and it includes all submissions. I have used the "old" report as the grid for new reports when published do not include the selection criteria, and cannot sort.


    the form is https://www.jotform.com/build/201341380005034

    Screenshot
  • Profile Image
    VincentJay
    Answered on May 25, 2020 at 07:14 PM

    Unfortunately, I was not able to fully understand the issue. To create a Grid Report, please check this guide: https://www.jotform.com/help/105-How-to-Create-a-Grid-Listing-Report

    Or, are you looking for the newer version of the submission page? Here's the updated one:

    1590448184vgfax.png

    If I misunderstood your question, please let us know. Thank you.

  • Profile Image
    SouthernUnitedHC
    Answered on May 25, 2020 at 08:03 PM

    If you go in to Visual report view  and go to old version.  I had tried using a visual report view (and publishing that) but as per a previous report to support the filters do not work when published, therefore I needed to use the "old version"


    these reports can also be seen under reports for the form

    1590451147add report.png

    1590451167old view.png

    1590451401reports.png

  • Profile Image
    Kenneth_C
    Answered on May 25, 2020 at 08:11 PM

    Hello there,

    To clarify, you wish to sort the report by a specific date?

    If so, then, unfortunately, that's no possible since you will only be able to sort the date either by ascending or descending but cannot select a specific date as a starting point.

    Apologies for the inconvenience and thank you for your patience.

  • Profile Image
    SouthernUnitedHC
    Answered on May 25, 2020 at 08:14 PM

    No, the problem i have  is that the filter is set to submissions only in the past 1 day, but as you can see it is showing submissions from 4 days ago.


    1590452008jotform last 1 day.png

  • Profile Image
    Kevin_G
    Answered on May 25, 2020 at 08:40 PM

    Apologies for the inconveniences caused. 

    I have been testing the report and this seems to work, I've set multiple filters like your report, here is the result: 

    15904533752020-05-25_18h30_02.png

    May you try switching the "Match" filter to any and then to all? 

    This should update the settings, let us know if the problem persists. 


  • Profile Image
    SouthernUnitedHC
    Answered on May 25, 2020 at 08:51 PM

    Thanks



    I have done that and it has not made any difference. 


    The problem seems to occur when there are multiple filters. Should it work with multiple filters ?

    1590454140Untitled 13.png

    1590454246Untitled 14.png


  • Profile Image
    roneet
    Answered on May 25, 2020 at 09:46 PM

    We are sorry for the inconvenience this has caused.

    I was able to replicate the issue in your form. It seems the multiple filters is not working on the Visual report builder. Let me escalate the issue to our development team.

    We will get back to you once we have an update.

    Thanks.

  • Profile Image
    SouthernUnitedHC
    Answered on May 31, 2020 at 08:27 PM

    Hi

    Is there any likelihood that this problem will be corrected?


    Thanks


  • Profile Image
    roneet
    Answered on May 31, 2020 at 10:12 PM

    This ticket is already assigned to a developer and they are working on it. Unfortunately, We have not received an update from our backend team. We will get back to you once we have news on this form our team.

    Thanks.

  • Profile Image
    SouthernUnitedHC
    Answered on June 30, 2020 at 09:54 PM

    Just wondering if there is any news on this?


    Thanks


  • Profile Image
    roneet
    Answered on June 30, 2020 at 11:08 PM

    We are sorry for the trouble this has caused.

    I have made a follow up on your behalf to our backend team.

    We will keep you updated as soon as we receive any news from our team.

    Thanks.