INC count, each Inc pick one SLA,updated/stop time latest. others hide in PA report/analytics

MonishV
Tera Contributor

My requirement is dashboard report for INC counts, each INC pick only one SLA, (latest updated/latest stop time). 

Other SLAs don't show in reports, 

 

I'm using PA, and set the aggregation count distinct, 

But it display correct count, if I click on the value, it shows the all SLAs to every INCs. 

 

I need to pick only one SLA. 

 

1 ACCEPTED SOLUTION

AndersBGS
Tera Patron
Tera Patron

Hi @MonishV ,

 

It sounds like it's working as expected according to your configuration. In general, the PA will count distinct incident number, but when you click the listview, it will show all - this is again as expected. For me it sounds like you need to modify your conditions if only one SLA should show in list view. 

 

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

 

Best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

View solution in original post

4 REPLIES 4

AndersBGS
Tera Patron
Tera Patron

Hi @MonishV ,

 

It sounds like it's working as expected according to your configuration. In general, the PA will count distinct incident number, but when you click the listview, it will show all - this is again as expected. For me it sounds like you need to modify your conditions if only one SLA should show in list view. 

 

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

 

Best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Hi @Anders

Can you help me on this, which module can I modify to set the conditions, if can I add a script in PA indicator form? Then give Me a sample script. 

 

Thanks

Monish

Hi @Anders,

 

Can you help me on that, 

 

Thanks 

Monish

MonishV
Tera Contributor

Hi @Anders,

Can you please help me on that, detailed. 

 

Thanks, 

Monish