Publisher Chart Types and Options

Publisher can display Charts in the Web Channel in a number of ways and depending on the method choosen there will be a different selection of Chart Types. Generally the Publisher Chart tab is used for most charting as it’s the easiest to use and setup and also supports any Drill Throughs that may have been defined on the Query Builder.

Most of these methods support a common core of Chart Types with some unique Chart Types of their own.

• ​​Publisher Chart
  • ​These Charts are build into Publisher and will auto adjust most query data so it can be charted.
  • Supports Drill Through
  • http://www.philight.com.au/Lists/Posts/Post.aspx?ID=77

• Publisher Page
  • Has a good selection of Chart Types and also Sparklines
    
  • Manual Drill Through can be acheived by binding URLs to the Action property
  • http://our.componentone.com/wp-content/uploads/2009/05/AR6Designer.pdf​

• Publisher Excel
  • Any Chart contained in a ​Excel Worksheets can be Published to the Web Channel
    
  • No Drill Through on the Chart Elements is possible but Drill Through on the whole report is possible
  • http://www.philight.com.au/Lists/Posts/Post.aspx?ID=34​
  • http://www.philight.com.au/Lists/Posts/Post.aspx?ID=36​

• Publisher Query Expressions using Html and Images
  • Expression can call out the online visualization library such as Google Charts
    
  • Sharperlight also has a basic library of sparklines etc that are pre-rendered as images​
  • https://www.youtube.com/watch?v=FM7Frmk-oCw

• Publisher Custom HTML and JavaScript
  • Sharperlight using the Kendo UI for most of the HTML charts. Custom HTML can be used to build your own Chart with the Sharperlight Data.
    
  • http://www.philight.com.au/Lists/Posts/Post.aspx?ID=103
    
  • http://demos.telerik.com/kendo-ui/bar-charts/multiple-axes​

Publisher – Page List​ ​

Publisher – Query Expression

Publisher – Chart List

​Publisher – URL Parameter Options

The Publisher Chart Tab allows the most common settings to be set.  However there are additional settings that can be applied as URL parameters​ that can adjust or override the Chart’s existing attributes.

For example to change the Legend font size to 14 pixels you can add &fontSizeLegend=14 to the URL address or add this parameter to the Publisher  / Report / URL Parameters text input box.

For a full list of URL parameters please see the Web Channel Help

The example a URL address may look like this

http://myserver/mdService1Rest/Chart/?query=ADVW.ChartBar&ctype=bar&chartTheme=flat&showPointLabels=1&plotBandMin=1000000&plotBandMax=2000000&plotBandMin2=6000000&plotBandMax2=8000000&plotBandMin3=8000000&plotBandMax3=13000000&plotBandColor3=red&scaleMax=12000000​

Note:  There are a maximum of three Plot bands that can be underlayed on the Chart data area. Setting colours for the plot bands is optional as they will already default to green, yellow and red when not set.

Publisher URL Parameters

Chart URL options are put on the URL link to the chart to override some aspect of the chart that may not be available in the Chart user interface or need to be dynamically changed.
These URL options can be set in Publisher by using the Report Tab URL Parameters property.

Query Builder Output Name Options