Hello,
I'm working on data visualisation on APEX and I would like to use the "D3 Sunburst Chart", given in the "Sample Charts", available in the APEX "Packaged App" tab. I exported the plugin from the Sample application and imported it into my APEX application but I'm unable to make the plugin work the way it is supposed to.
I wrote an SQL Query like the one in the exemple with five colums :
| ID | PARENT_ID | LABEL | COLORVALUE | SIZEVALUE | LINK | INFOSTRING |
|---|
ID to identify each element
PARENT_ID to identify the parent element of the element
LABEL for the displayed value on the chart
COLORVALUE like LABEL
SIZEVALUE my numeric value
LINK Null
INFOSTRING like LABEL
And I fild "Page Item to Submit" field to avoid bug.
Unfortunately the result is a broken, random sunburst visualisation of my inputed data. Something markworthy is the fact that my Sunburst chart is completely dependent of my "ORDER BY" line in the SQL query, while the exemple Sunburst chart isn't that much impacted by the addition of an "ORDER BY" line in it's SQL Query.
Please could you explain me how the data in the query is supposed to be organised? I must have missed something but I don't know what.