What is the JSON data format for pivot tables in UI Builder?

lxinyu
Tera Contributor

‎08-27-2024 06:11 PM

Hi,

 

I am trying to populate a pivot table in UI Builder with data resources, however there doesn't seem to be documentation related to JSON data format for pivot tables. I've already built something like this:

 

lxinyu_0-1724807111704.png

 

These are what I learned from trials and errors:

  • When aggregateBy=0 is set in the metadata, it'll populate the bottom-right cell 
  • When aggregateBy=1 is set in the metadata, it'll populate the rightmost column (total counts for each row)
  • When aggregateBy=2 is set in the metadata, it'll populate the bottom row (total counts for each column)

I assume that when aggregateBy is set to 3, it'll populate the empty cells in the above table. However this is not the case and the cells are not populated. Thus I'm wondering what the correct JSON format is, any pointers would be greatly appreciated!

0 Helpfuls
  • 369 Views
1 REPLY 1

Community Alums
Not applicable

‎08-27-2024 06:24 PM

Hi @lxinyu ,

Please refer to the link : https://developer.servicenow.com/dev.do#!/reference/next-experience/washingtondc/now-components/sn-m...

 

0 Helpfuls