Can we create Dashboard Level Date Breakdown for Performance Analytics

[Eddie5]

Hi All,

How to create a date range breakdown for performance analytics widgets? I am aware that we can create date interactive filter for standard reports.

Though we are tried to get bucket groups in place as : 0-7 days, 0-15 days, 0-30 days, 0-60 days, 60+ days however this is not working, can you suggest / advice how to get this done?

Below is script we using for breakdown mapping : 

var diff=function(x,y){return y.dateNumericValue() - x.dateNumericValue();};
var days=function(x,y){return diff(x,y)/(24*60*60*1000);};
days(current.opened_at, score_end);

If there is any other way of creating a dashboard level date breakdown, please suggest!

[Mahak2]

Hello 

Please refer below:

you could create your own custom interactive filter (Custom interactive filters ).

To give you a head start, please find attached an update set that will create

-a new widget type ("Custom Interactive Filters") in which you can list for which dates you want to have interactive filters and

-a UI macro ("interactive_date_filter") that will generate the interactive filters as listed within the new widget type.

The result in the UI looks like this:

So like when in the condition builder, you can select:

-the date (A) to use in the filter,

-the operator (B) to apply,

-the operands (C) to set. The operands are of course dependent on the operator selected.

When developing or troubleshooting interactive filters, consider to add the "Debug homepage filters" (D) on your dashboard.

You could also have an interactive filter for which the date is fixed, so a user is not troubled by selecting the right date. It looks like:

Now, the user can only select the operator and operands.

To add the custom interactive filters to a dashboard when using the attached update set, it will look like this (with the responsive canvas plugin in Helsinki turned on):

So a new type/category of widgets (E), showing the dates as listed (F) in the new widget types.

In the new widget type ("Custom Interactive Filters"), you can list multiple dates for which you want interactive filters available in a 'condition builder' look and feel. It looks like this for the two interactive filters from screenshot above:

Thus

-give an interactive filter a name (1). This will show up on the widget;

-define the table (2). And if you want the user to be able to select for which date the filter should work (first screenshot), don't specify a field;

-define a specific field from the table (3) if you don't want the user to be able to select a date.

If you don't want every user to be able to add custom interactive filters to a dashboard, set the roles that should have access (4).

You can add more interactive filter dates to the list. For example:

resulting in:

Also refer this article:

https://community.servicenow.com/community?id=community_question&sys_id=f549ef9bdb1673001cd8a345ca961978

Hope this helps:

Please mark my answer as helpful/correct if applicable.

Thanks

[Eddie5]

Hi Mahak,

Thanks for an elaborated answer... I understand that interactive filters only work with standard reports and thus can not be used for performance analytics widgets. 
Please confirm if otherwise.?
Also, if there is any possible way to achieve Dashboard level breakdown for PA widgets, let me know.

[Manan Bhatt]

Hi Eddie5,

I have a similar ask from one of our clients and was wondering if you were able to accomplish this? Thanks!

[Eddie5]

Hi @Manan Bhatt , Due to limitations within servicenow we can not create a Date interactive filter to work with PA widgets; We have to separately setup Standard reports with Date filter and PA reports with age buckets.

Thanks!