Menu

Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Show posts Menu

Topics - ahasbini

#1
General Support / Scripted Pie Chart Example
December 08, 2024, 02:08:29 PM
In dashboard elements, there is the option of adding a scripted pie chart, I have tried to search the docs for an example but could not find any. Are there any guides on making a scripted pie chart?

Thanks,
ahasbini
#2
Hello,

I have a table DCI with the following data:


      COL1 (integer) |    COL2 (string) | VAL
       -----------------------------------------
          1          |       TEST1      |     5
          2          |       TEST1      |    10
          1          |       TEST2      |      8
          2          |       TEST2      |      6


COL1 is an instance column (key) and COL2 is instance column (key). All columns have aggregation set to SUM.

When creating a Pie Chart on dashboard based on the table DCI, I am setting the instance column to COL1 and Data Column to VAL. The pie chart is displaying two parts/arcs (1 and 2) but the value appearing is only of one row from each instance [5 and 10]. My expectations is that the VAL values are aggregated so that 1 has value 13 and 2 has value 16.

Could someone please tell me what I'm doing wrong here.

Thanks.