Charts prerequisites
Charts is a Publisher module. In order to display charts properly, the following steps are required.
Adding default chart colors to site
You can set the default chart colors to be used on site level. It is possible to override the default colors on web definition level.
 | Customers using Planon Accelerator can skip this step, as it is already configured. Continue with Adding a chart. |
Procedure
1. Go to Layouts .
2. From the list of business objects, select Sites and go to the Layouts level.
3. In the element list, select PssSite and set it to Under construction.
4. Click Add fields.
5. In the Unused fields section, select all chart color fields and drag them to the layout panel .
6. Set the layout status back to Completed.
The chart color fields are now available to all sites. You can change the default colors as required.
Specifying colors for Dual-Y secondary Y-axes
Dual-Y combination charts can have a maximum of 5 secondary Y-axes.
The Y-axis can be enabled on the chart's Appearance tab.
The colors for these Y-axis are automatically assigned in a specific order:
• Secondary Y-axis 1 takes color 2
• Secondary Y-axis 2 takes color 3
• Secondary Y-axis 3 takes color 4
• Secondary Y-axis 4 takes color 5
• Secondary Y-axis 5 takes color 6
| | Color 1 is reserved for Primary Y-axis (if available). |
In order to assign a unique color to each of the axis, you can specify colors 2 to 6 on the chart's Colors tab.
Getting unique values
For Publisher DualY charts and queries containing X-axis sub it is important that the values for the X-axis column are unique - if this is not the case, data might not be shown.
If your query includes the Name of a property, and it is not unique within the set of properties, the data is shown but the chart 'behaves' unexpectedly.
You can prevent this situation by including an extra filter on property to ensure its uniqueness.
This is possible by using the CONCAT function, where 2 values are combined to generate a unique identifier, or by choosing a different field.
Example
Let's assume the Name of properties in your set is not unique and the following query is used:
SELECT ADRES.NAAM as Xaxis,
ADRES.SYSCODE as Xaxiscode,
Count(ORD.SYSCODE) as YAxis,
15 as YAxis1Sec
FROM ORD
INNER JOIN ADRES on ORD.SYSADRUITV = ADRES.SYSCODE
WHERE ORD.NAAM IS NOT NULL AND ORD.STANDAARD = 'F'
AND ((1=1)
AND ( ( (ORD.BEHCODE = 'BP') AND (ORD.SYSADRUITV IS NOT NULL) ) ))
GROUP BY ADRES.NAAM, ADRES.SYSCODE,ADRES.CODE
ORDER BY ADRES.NAAM
ADRES.SYSCODE as Xaxiscode,
Count(ORD.SYSCODE) as YAxis,
15 as YAxis1Sec
FROM ORD
INNER JOIN ADRES on ORD.SYSADRUITV = ADRES.SYSCODE
WHERE ORD.NAAM IS NOT NULL AND ORD.STANDAARD = 'F'
AND ((1=1)
AND ( ( (ORD.BEHCODE = 'BP') AND (ORD.SYSADRUITV IS NOT NULL) ) ))
GROUP BY ADRES.NAAM, ADRES.SYSCODE,ADRES.CODE
ORDER BY ADRES.NAAM
The query results in a duplicate value for the X-axis. To make the value unique, you should use ADRES.CODE or CONCAT(ADRES.NAAM,ADRES.CODE) to get unique X-axis values.