How do I customize my report to actively show my Agency prodcution from Sunday Through Saturday range of the current week and hide older data?

  • aibins
    Asked on October 3, 2014 at 12:43 PM

    I have the report currently imbedded on my agency tracking page and when an agent submits the form, it refreshes the page and automatically show their production added to the report.  I would like to specify the report so that it only shows production submitted from Sunday - Saturday of the current week, and any data submitted prior to the Sunday of the current week just archives and does not actively show. 

    I also would like to know if there is a way to add a column or additional report below the one on this page that shows the agents accumulated value for the week and rank them from top to bottom with the highest producing agent showing number 1. 

    Thanks!

  • David JotForm Support Manager
    Replied on October 3, 2014 at 1:39 PM

    As far as I know,  it is not possible to hide entries based on conditions since the reports are hard coded.