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

Messages - ahasbini

#1
General Support / Re: Scripted Pie Chart Example
December 08, 2024, 04:42:18 PM
Thanks a million, I just couldn't figure out the map or array part out from the docs so I had to ask. I'm familiar with the DCI part, so I will give it a try. Thanks again.
#2
General Support / Re: Scripted Pie Chart Example
December 08, 2024, 02:09:33 PM
Specifically, an example on the script used in the Scripted Pie Chart to display in the dashboard based on some logic that retrieves data from DCIs.

Thanks.
#3
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
#4
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.