How can I achieve the below report using PA

[harsh822]

I am trying to develop below attached report,

But not able to find how can I show 2 columns of different months for a assignment group.

Tried everything but not able to achieve the desired result.

Thanks In Advance

[AndersBGS]

Hi @harsh822 ,

please share your current configuration, then it will be much easier to help you.

if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[harsh822]

Hi Anders,

Thanks for taking this up,

So, the configurations are as below:

Indicator source - on incident table with filter resolved on today

Indicator - on incident table

Breakdowns - 1. Assignment group 2. Cause code

Breakdown sources - 1. Groups - with condition (active = true) on sys_user_group table, field = sys_id 

                                     2. Cause codes - with condition on sys_choice table, field = sys_id

Break down mapping - table = incident and field = cause code

Data collector jobs - Historic and daily

Widget - Snapshot attached

Currently I am getting below result

I need to split each column in 2 halves to show the data of different months.

Thank You

[AndersBGS]

Hi @harsh822 ,

I don't see it as possible to ad another widget indicator to the current widget when having the breakdown visualization. 

if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[harsh822]

Hi @AndersBGS 

So how can I achieve the above result that is mentioned in the problem?

Can you please give me some steps that I can follow.

Thank You