Skip to main content

KPI Column by MAQ Software

MAQ LLC
Here is a column chart where each column will behave as an indicator when compared with a line

Column color updates dynamically based on the difference in column height and their respective target line value. Adding common threshold value exists for all columns. For upcoming values, the same target line can be used for forecasting and column will be displayed in separate manner (in translucent color) to show them as forecasted values.

Below mentioned are the basic requirement and method to use the KPI column:

1) Measure data field and category data field are required.

2) To differentiate forecasted data, add a column which will contain 0's and 1's in forecasted field. 0 - normal, 1 - forecasted (dashed bars)

3) Adding data in full year target field will display a target line in the chart.

4) Add data in individual target field to display individual target line in the chart.

5) If individual target field is set, then you can update bar colors based on values specified in zone 1 upper bound and zone 2 upper bound fields in formatting pane.

Ex: zone 1 upper bound – 90 and zone 2 upper bound - 101

This will create three zones: 0-89, 90-100 and 101 - above.

If bar value is < individual target by 90% then 'Low' color will be applied.

If bar value is >= individual target by 90% and < 101, then 'Medium' color will be applied.

If bar value is >= 101, then 'High' color will be applied.

6) Formatting options for Y-Axis - color, display units and decimal points.

7) Formatting options for individual target - on/off, line color and stroke width.

8) Formatting options for Target - on/off, line color and stroke width.

Add-in capabilities
When this add-in is used, it
  • Can read and make changes to your document
  • Can send data over the Internet
  • https://az158878.vo.msecnd.net/marketing/Partner_21474837161/Product_42949681048/Asset_b734cb0e-d555-4c1d-8c5b-62cedac983bd/KPIColumnPrimary.jpg
    /images/videoOverlay.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474837161/Product_42949681048/Asset_b734cb0e-d555-4c1d-8c5b-62cedac983bd/KPIColumnPrimary.jpg
    /images/videoOverlay.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474837161/Product_42949681048/Asset_b734cb0e-d555-4c1d-8c5b-62cedac983bd/KPIColumnPrimary.jpg
    https://az158878.vo.msecnd.net/marketing/Partner_21474837161/Product_42949681048/Asset_73775838-ee6a-4e19-8560-4d12b9154416/KPIColumnSecondary.jpg
    https://az158878.vo.msecnd.net/marketing/Partner_21474837161/Product_42949681048/Asset_e4b4762c-8083-4330-9d32-cc2dbc00e843/KPIColumn3.jpg