Menu

Page Designer – Gantt Charts and Chart Tab

​Gantt Charts allow you to organise data by a Start and Finish Date or Start and Finish Value by the desired category.  This post will show two methods for creating Gantt Charts, one using Publisher Page Designer and the other using the Publisher Chart type Gantt.

In this example we will create a Query that has a list of people involved in a Project and their Start and Finish Dates.

Publisher Page Designer

Project Schedule Gantt Chart when viewed in the Web Channel 

PublisherPageDesignerChartWebPreview.png

In Publisher use Query Builder to create a Dataset that has a Category and Start and Finish Date

Notice that Start and Finish Values can also be used in a Gantt Chart but in this example they are not used

PublisherPageDesignerChartGanntDataPreview.png

In Publisher goto the Page Tab and click the Edit button to start the Design Process

PublisherPageDesignerChartGanntPageTab.png

​ Delete any Tables and Drag out the Chart onto the Design Area then set the Chart Type to Gantt

PublisherPageDesignerChartGanntCreate.png

Right Click on the far right hand side of the Chart to get the Full Chart Menu an select Chart data

PublisherPageDesignerChartGanntDataMenu.png

Select Servies Values and Set the Label and the Fields to use for the X (Start Date) and Y (Finish Date) of the series.

PublisherPageDesignerChartGanntSeriesValues2.png

Select Category Groups and select the Field to be used in the Expression Box

PublisherPageDesignerChartGanntCatGroups.png

As the example is using Start and Finish Dates Select the Y-Axis from the right click menu and set the Date Format MMM dd

Date formats:

http://msdn.microsoft.com/en-us/library/8kb3ddd4%28v=vs.110%29.aspx

PublisherPageDesignerChartGanntY-Axis.png

Peview the Report and if required change the appearance and axis grid lines to suit

PublisherPageDesignerChartDesignPreview.png

Multiple Series Values in the Same Row

It is also possible to create multiple instances in the same row using Gantt charts.

Showing today’s date as a dotted line

If one was to create another set of Series Values and set that to always be todays date then it will mark today’s in the Gantt as a vertical dashed line.

 

=DateAdd(“d”,1,Today())

 

Publisher – Chart type Gantt

If a dataset is defined in Query Builder with the correct columns and  data then it can be rendered as a Gantt Chart as see in the Web Channel screenshot below.

Download Published Report Gantt Example  (Use Publisher Import)

 

Query Builder Showing the Gantt Dataset

Setting the Chart type to Gantt in Publisher

Options

This type of Gantt Chart type on the Chart tab will required v4.7 or aboveIt also has an export to PDF button at the top  (Sample Publisher report attached for import)

By default it will show the Week view but this can be changed with a url parameter  &plotView=day  or &plotView=month

 

To change the default view to week and also turn on the current time marker combine week and currentTimeMarker with a underscore.

&plotView=week_currentTimeMarker

Set the URL parameter in Publisher in the Options tab in the URL Parameters section.

Data Columns

  • The start and end dates can also have time
  • The only mandatory columns are Id, Title, Start Time and End Time
  • If one does not want columns like ID , Start or End to be displayed you can obscure the outputs

Related Posts