Discussions

Expand all | Collapse all

Data not populated for particular year

  • 1.  Data not populated for particular year

    Posted 07-11-2017 19:58
    I am newbie in using Quickbase and I recently joined an organization which uses Quickbase. The application is pretty complex with lot of relations and formulas and now the problem is In the reports data for year 2017 is not populated and I am not able to figure out why. Can anybody tell me how should go about it? Thank you


  • 2.  RE: Data not populated for particular year

    Bronze
    Contributor
    Posted 07-11-2017 20:02
    Is it possible the report had a fixed range and its not including 2017? Go to the report and click customize if you have permissions and check the criteria of the report. Anything different about 2016 vs 2017 data that you can find that may be the culprit?


  • 3.  RE: Data not populated for particular year

    Posted 07-11-2017 20:07
    Thank you for your response.
    The filter is set to show transactions "is on or after" the date 01-01-2015. I am able to see the data and charts upto Dec 2016 only.


  • 4.  RE: Data not populated for particular year

    Bronze
    Contributor
    Posted 07-11-2017 20:08
    What field is it using? Date created or another date field?


  • 5.  RE: Data not populated for particular year

    Posted 07-11-2017 20:22
    Another Date field which is used somewhere else and after tracking from which form it is being used. It is calculated by formula by adding two fields and I am not able to find the fields also. I am really confused.


  • 6.  RE: Data not populated for particular year

    Bronze
    Contributor
    Posted 07-11-2017 20:25
    Sounds like you're getting closer though! I'm hopeful that once you track them down you'll find your issue and will most likely be a simple fix from there. Good luck!


  • 7.  RE: Data not populated for particular year

    Bronze
    Contributor
    Posted 07-13-2017 18:11
    I've seen some apps where the programmer has created a Date table to store one record for each date. It is pre-populated with a record for each date, and the programmer arbitrarily stops at the end of some year in the future when they first created the app. Time goes by and the Date table is now in the past. See if you have a table like this and when the records end. The solution might be to add records for 2017 and going forward.