Forum Discussion

ManojKumar's avatar
ManojKumar
Qrew Trainee
8 years ago

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?

2 Replies

Sort By
  • Eric_J_Hansen's avatar
    Eric_J_Hansen
    Qrew Cadet
    8 years ago
    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.