Performance Analytics: Empty vs Not Empty field

[NikitaKale]

Hi

I have a requirement to create a bar report in which column 1 indicates all the assets who have an assigned to empty and column 2 indicates all the assets who have an assigned to non empty.

Would like some suggestions on how it should be implemented with or without using performance analytics.

Thanks & Regards,

 Nikita Kale

[RaghavSh]

This can be achieved with simple report, you dont need PA for this.

did you try creating the report on asset table?

[NikitaKale]

Yup, I did but the thing is if I create a bar graph and group it by assigned to field it would give me empty column + no of columns per assigned to names. But I need only 2 columns assigned to empty & not empty.

[AndersBGS · Accepted solution]

Hi @NikitaKale ,

Just utilize the report designer, and create one bar chart for "assigned to is not empty". Afterwards you add an additional dataset to the report, where your condition should be "assigned to is empty". You can see the ServiceNow product documentation here for adding a dataset to a report: https://docs.servicenow.com/en-US/bundle/vancouver-now-intelligence/page/use/reporting/task/t_AddAnA...

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

Best regards

Anders

[NikitaKale]

Hi @AndersBGS 

Wow, that worked like a charm! Thanks to you, got to learn a new concept today 🙂

Regards,

Nikita Kale