Reporting on Variables

[Natsufab3]

i need to find a way to report on variables where each variable question is my column in record. i have seen few post on database views but it dint work although i was able to generate variable question as column names there isnt any record related to it.

Does anyone have any idea regarding this? It would be helpfull

Thank you

[Natsufab3 · Accepted solution]

This 1 way i am trying to generate report is as table being question answer, and with each question as a condition filter with table name as incident and value not being empty. and it is working out although i couldnt get the variables as column name, i get them like rows. Something is better than nothing aint it!

Thank you

[gyedwab]

If you want the ability to generate reports with variables in the columns, you can use Explore Analytics. Here's a sample:

List with Variables

Explore Analytics reports are live. All you have to do is drag and drop, and specify which variable you want to show in the columns. You can filter/group/aggregate on as many variables as you need, and then publish to the ServiceNow dashboard, where logged-in users can drill through to the data.

You can sign up for a free 30-day trial here -- all you need is to apply our update set and provide a service account.

[gyedwab]

There's also a video with other variable use cases:

Reporting on Variables in ServiceNow - YouTube