Discussions

Expand all | Collapse all

Trend Chart over calendar year!

  • 1.  Trend Chart over calendar year!

    Posted 03-17-2017 20:55
    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.  RE: Trend Chart over calendar year!

    Bronze
    Contributor
    Posted 03-17-2017 21:19
    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.


  • 3.  RE: Trend Chart over calendar year!

    Posted 03-20-2017 12:25

    Thank you.