Data not populated for particular year

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
  • (Edited)
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
Photo of chetan patil

chetan patil

  • 210 Points 100 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Chuck Grigsby

Chuck Grigsby

  • 2,100 Points 2k badge 2x thumb
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?
Photo of chetan patil

chetan patil

  • 210 Points 100 badge 2x thumb
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.
Photo of Chuck Grigsby

Chuck Grigsby

  • 2,100 Points 2k badge 2x thumb
What field is it using? Date created or another date field?
Photo of chetan patil

chetan patil

  • 210 Points 100 badge 2x thumb
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.
Photo of Chuck Grigsby

Chuck Grigsby

  • 2,100 Points 2k badge 2x thumb
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!
Photo of Michael Barrow

Michael Barrow

  • 2,216 Points 2k badge 2x thumb
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.