Filter PA widgets AND Reports in one interactive Dashboard

[Simon41]

Hi all,

recently we upgraded from ITSM Std. to ITSM Pro.

Now we can use Performance Analytics and I have one question to this.

How is it possible to filter PA widgets and normal Reports on a dashboard via interactive filters? But we could not find any working solution. 

We want to build a full interactive dashboard for the whole company and we want use interactive filter with PA widgets and normal Reports.

Thanks!

Simon

[Tushar Hirpurk1]

Hi Simon,

You can do by selecting the Breakdown which will act as an interactive filter as well.

for Ex:- if you have 4 widgets on Dashboard in that 2 are for PA and 2 are for Report

now want to create a single filter which will act for both PA and reports widget as well,

in that you need to create a breakdown which will filter out the PA widget for you and 

in the property of that breakdown you can select that breakdown to act as interactive filter as well 

for remaining 2 report widget.

to know more find below link:-

Breakdown act as interactive filter

Please mark reply as Correct/Helpful, if applicable.

Thanks,

Tushar

[NikEng1]

Unfortunately, PA widgets cannot follow interactive filters in the same way as reporting widgets can.

In a PA dashboard, you can have what is called a "dashboard breakdown". This is a filter on top of the dashboard, where you can chose one or more elements from a breakdown source. All PA widgets configured with "follow element" and whose indicators have a breakdown based on the same source as the dashboard breakdown, will then be filtered.

When a dashboard breakdown is set up, you can configure that breakdown source to act as an interactive filter. For example, if the breakdown source is based on sys_user_group, when an element is selected it can also act as the input for the interactive filter "Incident Assignment Group". Note that this interactive filter isn't displayed on the dashboard itself, or added as a widget. Its simply a part of the dashboard breakdown.

However, what you cannot do is make the relationship go the other way. I think what you're after is adding interactive filter widgets to the dashboard, and making the PA widgets follow them. That is not possible. The only way to dynamically filter PA widgets is with the dashboard breakdown filter on top of the dashboard. 

Nor is it possible to have reporting widgets act as interactive filters, and have the PA widgets follow them. For example if you set up a pie chart and clicked one of the slices, you could have the other reporting widgets update and only display that data subset. That is not possible for PA widgets.

You could possibly create a custom scripted interactive filter, and set it to invoke the same method that the dashboard breakdown uses to update the PA widgets. I'm sure it's possible but I haven't tried it. For reference, when a dashboard breakdown filter is changed, an event is sent to the dashboard along with an object containing the sys_id of the breakdown source and the selected elements. If you set your custom interactive filter to send this event, maybe it would work:

var data = {
'source': $scope.selectedBreakdownSource.id,
'element': $scope.selectedElementIDArr.join(','),
'elementValue': $scope.selectedElementValues.join(',')
};
SNC.canvas.eventbus.publish('setBreakdownParams', data);