Skip to main content
Question

Trend Chart over calendar year!

I am looking to create trend data of defects over the calendar year. In the trend chart, I use the date field as X axis based on the entry of the defects. Our problem is when we hit zero, the date is not shown as we do not have any entry for that date period. Can you help me trend data over calendar days even if we do not have data during that period?
      This topic has been closed for replies.

      You could create a days table with the key field being the date. relate that table to the defects table, then summarize the number of defects. Now you can create a report on the days table and each date will be represented even if 0 defects occurred.
      • ManojKumar
      • Author
      • Registered
      • March 20, 2017

      Thank you.


      Terms & ConditionsAccessibility statement