Report on Specific Day of Week

[Cammi Dawn]

I am trying to create a report for our Ops Managers that shows how many cases come in on whatever day of the week it currently is.  I see where I can have a report that shows cases per day but I can't figure out how to pick out "This day of the week"

[Logan Poynter]

Hello Cammi,

Are you meaning day of the week like "Cases opened Monday, Tuesday, etc." over time? You should be able to use the Trend operator for opened/created/etc, and then use a script includes to call a script that pulls back whatever day of the week it is. 

For example, Created TREND ON javascript:getDayOfWeek() or whatever you call your script

EDIT: I stand corrected, using TREND does not allow you to type in and you're given only select boxes for the Day. You would either need to create 5 reports for each day of the week (or 7 if you need weekends) or potentially look at using PA in some way to achieve this breakdown with a bucket group and scripting. 

Please mark my answer as correct/helpful if it has helped you.

Thanks,
Logan

[Cammi Dawn]

I thought I might have to use PA to do this.  I'll have to work on the breakdown for PA.  I am still working on learning PA but I was afraid that was going to be the answer.

[Logan Poynter]

Hello Cammi,

I'd be happy to help with any PA questions you might run into! It seems more intimidating than it really is but is well worth it once you do learn it! 

Please mark my answer as correct/helpful if it has helped you.

Thanks,
Logan

[Saurav11]

Hello,

You mean the cases which came in on the day they view the report?

You can simply add the filter created on today

Incase your requirement is something else let me know.

Thanks.

Please mark answer correct/helpful based on Impact