Calendar Charts: Displaying Multiple Events

This will require Builder privileges for setup and implementation.

The charts: Monthly Calendar, Monthly Event Calendar, and Weekly Calendar display only one row of data for each date cell (i.e. If there are multiple rows of data with the same date, the chart will use the first date occurrence, and ignore any other data. If there are multiple events for a given date, these additional events will be in the form of additional rows of data with either the same date and time, or same date but with variation in time. Only the Daily Calendar has worked to display multiple events for each day, with only two columns of data. 

Resolution:

Since this calendar chart considers only the very first row of information relating to the date as one event, and shows only one event or row of data on the chart, you could add additional events on a given day in the form of an additional two columns (Y-axes). You will be able to see all the events on a given day for the charts: Monthly Calendar, Monthly Event Calendar, and Weekly Calendar.

Original Data Format:

Multiple Event Data Format:

For More Information:

• iDashboards Builder Manual 8 Designing Charts
• iDashboards Builder Manual 9.12 Calendar Charts
• Dashboard & Chart Design Articles

If the above is unable to resolve the issue, then please contact truOI Support for further assistance.