Question

Pie Chart woes

Forum|Forum|2 years ago
December 12, 2023
9 replies
1 view

I'm currently trying to add a Pie chart into a reporting page.
The report is doing a record type query and simply pulling back

Id
Items

The issue is my Items are an array

The DB table looks like

1 Widget

2 Widget / Whatsit

3 Whatsit / Dohicky

i would like my pie to show a slice for each item, but at the moment I'm getting a slice per item (so 3 in total)
How can i split the data so i have a slice for widgets (2 items), a slice for whatsits (2 items)and one for dohicky (i item)

stefanhelzle0001

Brainy

Did you already check the documentation for some inspiration?

docs.appian.com/.../Chart_Configuration_Using_Records.html

stewart.burchell

My first instinct is that your underlying data model is incorrect. If the outcome you want to display a pie which has Widget (2), Whatsit (2) and Dohicky (1) then your database table should have two Widget rows, 2 Whatsit rows and 1 Dohicky row.

If you have no control over the data model then you'll need to manipulate/coerce the data that is returned so that it meets your needs.

pauls0010Author

Hi Stewart,
The above was an example. the se case is that in another part of the site, a user can select multiple items of many different types.
Effectively each row in the DB is an order for multiple items. The list of items per order are stored in an array and written out to the db in a single column.

I am trying to show in reporting how many of each type is ordered. It would not be very efficient to have a table with a column for each item. (which may change as we add / decrease the items)

stefanhelzle0001

Brainy

Storing multiple values in a single field is a difficult design decision. Is that done by intention? How does your entity relationship model look like?

Sign up

Login with SSO

Login to the community

Login with SSO