Back

Charting
chartLens
Fields listed in this lens are displayed as charts The field must be of type integer or numeric. There are two types of charts you can create. Bar Charts The first is a horizontal bar chart. If the chart has both negative and positive numbers, you can choose two different colors for the negative and positive values. Chart dimensions must be set for bar charts. This is the maximum size of a chart. Set the width and height. To fit the chart into the chart dimensions, phpLens needs to estimate the maximum and minimum values of the field. You can provide an SQL statement to calculate it here, or hard-code numeric values (this is faster). Icon Chart The other chart is the icon chart, which shows a picture for every Scale units (rounded up). Setting Chart Min/Max The scale of the chart is determined by these settings. Chart Min is the smallest possible value and Chart Max is the largest possible value in that column. You can set this value manually (default), or execute an SQL statement to do this, normally:
    select min(col),max(col) from table
From these values and the Chart Dimensions, phpLens is able to scale the chart correctly. Syntax `$lens->chartLens = 'Col1;Col2;Col3';` Basic:Yes Advanced/Enterprise:Yes DynamicEdit:Yes [Version 1.0]