GlideRecord to Widget

[tvrdojevici]

I have 2 different tables (A and B) I would like to write to an array certain columns (categories and how many people in each category) from each of the 2 tables (From table A categories 1,2 and 3, from table B categories 4,5 and 6) and then show that data in a widget (eg. vertical bars with 6 bars that represent the 6 categories and how many people in each category)
Is this possible or can widget only read data from tables and not from arrays in scripts.

Thanks in advance

[tvrdojevici]

A very crude visual representation of what I would like to achieve, of course if this is possible without an array that would be great
Another solution is to load the data from table A and B to another table and then represent that table with a widget
Those are just solutions that came to mind, if there is a standardised way to do this please let me know