Trend Chart over calendar year!

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
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?
Photo of Manoj Kumar

Manoj Kumar

  • 122 Points 100 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
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.
Photo of Manoj Kumar

Manoj Kumar

  • 122 Points 100 badge 2x thumb

Thank you.