paulsondervan

Pie chart not working as expected

Discussion created by paulsondervan on Jan 23, 2017
Latest reply on Jan 24, 2017 by user19752

I'm trying to create a pie chart.

The data for the pie chart consists of 1 record with 2 fields.

These 2 fields (total patients (109) and patients reviewed (40)) should create the pie chart.

 

I use this for the calculation in Slice data:

Let(

[

~QryRes = ExecuteSQL ("SELECT GecorrigeerdePatienten, TotaalAfspraken

FROM Artsen

WHERE Arts_Code = ?" ; "¶" ; "" ; Dashboard::Arts01 );

~PieVal1 = GetValue ( ~QryRes; 1);

~PieVal2 = GetValue ( ~QryRes; 2);

~RetVal = List(~PieVal1;~PieVal2)

];

~RetVal

)

 

The result is this:

PiechartProblem.png

As you can see the 109 for total patients and 40 for the patients reviewed are found, but the data is seen as one big value and not as 2 separate values.

What am I doing wrong?

Outcomes