Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Needing Help With a Quarterly Report

Hi! So i've been struggling with this the last 24 hours and I wanted to see if any of you out in this amazing community might be able to help me finally get it figured out.   I've got a quarterl...
Need Help
Tips and Tricks
Tutorial Requests
davehus's avatar
davehus
Memorable Member
4 years ago

Hi @, Is there a month number or anything else in the report that isolates it to a month?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Dave!

Unfortunately that's where I'm running into the issue.  These reports in particular don't have any data that distinguish when the tickets were created, so it's not allowing me to break them down by month.  if I go into the raw data itself, and add that "Opened/Created" option, where it does create the date field, it throws my existing table completely off.   Not sure how to get this unraveled.

  • davehus's avatar
    davehus
    Memorable Member
    4 years ago

    Hi Anonymous , without any date context then it wouldn't be possible.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Dave!

      There is a way to put in the Month field, and not have it omitted from the report in SNOW (just had to use Opened or Start).  Problem is though when I do that the formula goes completely wonky and everything gets thrown off, so there is something that's causing it to go haywire, and the only thing I'm doing is adding the Month field.  So that's why I'm not sure how to fix it.