Pivot.js question (closed)

[digs_servicenow]

2022 October edit

This post has been archived with no answer

Hello knowledge community! I have a complex question.

Has anyone attempted to create a working integration with pivot.js and a ServiceNow instance; if so, how?

[chirag_bagdai]

Hi,

I would suggest you to check out "Reporting" & "Performance Analytics" modules/plugin in ServiceNow platform which can give you the functionality/UI where you don't need to prepare JSON at all and create reports in seconds.

If you have data in CSV/Excel file, you can load them easily with "Load Data"   module.

and if you are looking for PivotTable.js to use in UI page, you can do it.. just try with importing required library and providing sample JSON.

Please find below reference URL :

Getting started with reports

Performance Analytics and Reporting  

Let me know in-case of any question.

[digs_servicenow]

Thanks Chirag!

I have checked out (and had a lot of analytic fun) with Performance Analytics as well as reporting. Combining reports of pie charts and bar charts alongside indicators is incredibly powerful, and I really enjoy it. In a lot of situations, I make pivot tables and pie charts to make my testing much faster and easier.

The reason I want to connect pivot.js with a source of data like ServiceNow, is that there are some things that it does that are not doable in ServiceNow reporting.

One example:

        Aggregation (in a pivot table) that allows for count as a fraction (percentage) of the (columns, rows, or total)   (go to https://jsfiddle.net/nicolaskruchten/gq6w05j8/, change the main dropdown to table, and the second dropdown to count as a fraction of total). I would really like to be able to get those percentages and then use coloring rules to define 100%-76% as red, 75%-25% as yellow, and 24%-0% as green.

If there is any way I can do this, please let me know.

I would like to note that, the way that I want to connect pivot.js to ServiceNow, is essentially, a person would input a table choice, then put in a query, choose a max record count, and then input a list of fields that they want. After all that they would press a "load pivot" button, and the queried table's records (reduced down to the list of fields they chose) would populate into the pivot table on the page.

[gyedwab]

Hey,

If you are looking for a tool that will get you as extensive of pivot reporting as you need, here's the example you mentioned above created codelessly in Explore Analytics:

Defining the % of Total looks like this:

Defining the coloring rule looks like this:

For the columns, it's actually doing a date conversion to automatically turn the "opened" date-time into an "age":

All of this is real-time against ServiceNow, and can be published into the ServiceNow dashboard, will drill-down capability and security / contextual filters applied: