Is there a way to do a PA Breakdown by day of week?

George P
Tera Guru

Is there a way to do a PA Breakdown by day of week?  For example, I have have an indicator for New Incidents Daily.  What my management would like to see is a trend of new tickets on Monday, Tuesday, etc.  In other words, if yesterday was Monday, was it like every other Monday or higher, or lower ticket volume.  I know I can do this with a trend chart, but that runs on the live data and I would prefer for it to run on the PA Collections.

Thanks in advance,

George Palm

1 ACCEPTED SOLUTION

George P
Tera Guru

As a follow-up, after much patience and research, I have been able to create a Day of Week breakdown without any new fields.  Here are the basics if someone else is looking to do this.

1. Create a Bucket Group named Day of Week.  Add an entry for each Day starting with Monday (unless your week start day is different) with values as follows.

Monday START = 1, END = 2

Tuesday START = 2, END = 3

Wednesday START = 3, END = 4

Thursday START = 4, END = 5

Friday START = 5, END = 6

Saturday START = 6, END = 7

Sunday START = 7, END = 8

 

2. Create a Breakdown source Day of Week

Facts Table = Bucket

Field = Sys ID

Condition: Bucket Group = Day of Week

 

3. Create a script (table of your choice, one script per table)

Field = any date/time field

var getDayOfWeek = function (x){

var gdt = new GlideDateTime(x);

return gdt.getDayOfWeekLocalTime();

};

getDayOfWeek(current.field name from above);

 

4. Create an Automated Breakdown Day of Week

Breakdown Source = Day of Week

 

5. Create a Breakdown mapping - Use the same table as you used for the script.  Be sure to reference the correct script.

6. Add breakdown to Indicators and run your collections.

View solution in original post

5 REPLIES 5

Is there a way to do a PA Breakdown by weekly and monthly?

 What i would like to see is new tickets opened on last week/this week, last month/this month  etc. 

I tried using the bucket groups i m not sure what should be start and end values for last week, last month, this week, this month

when the user selects breakdown(Timeline) on dashboard the user should be able to pick options

last week

this week

last month

this month

 

just like when we create reports we filter created or opened on this last week this month etc right I m trying to show these on breakdown.

 

please let me know if you have any lead on this.

Thanks.