How to build 3 year control report that only includes full months of data
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-18-2025 12:44 PM
Problem example - today is 6/18/25 (midway through the month)...
I'm creating a control report (because the trend line is important) that shows count of incidents by month looking back 36 months, however I don't want to include partial month data (6/18/2022 - 6/30/2022) because the 'half month of data' scews the trend line. Ideally I want this chart to automatically look back 36 (full) months from "now" - so eliminate any partial months on either end and only give me 36 full months of data.
I am able to eliminate the 6/1/2025 - 6/18/2025 data (which would also be a 'half month' count) with adding "Created before this month" criteria.
This control chart uses "created relative 36 months ago" and inlcudes only half (6/18/22 - 6/30/22) of June '22... the trend line is quite flat... (side question: HOW THE HECK to I change the color of that NEARLY INVISIBLE trend line on a control chart??)
This control chart uses "created after 6/1/2022" ("hard coding" a full months of data)... the trend line is very different (and more accurate)
Is there a way to only inlcude full month counts?