Our goal is to plot both process temp and outside temp represented as bars, one on top of the other, aka a stacked bar chart. A successful implementation will look like figure 1 which displays process temp & output temp as stacked bars.

Figure 1

Here are some detailed steps for creating a stacked bar chart in perspective:

Step: #1

Figure 2

First, we need to start with the X & Y chart,

The default timeseries bar chart does look like a stacked bar chart however, it has limitations.

Figure 2 shows one of the biggest limitations of the time series bar chart. The width of the bar chart is calculated automatically based on the amount of data already on the x- axis, so if you have sparse data with a wide time range then this bar chart will end up as thin vertical lines.

Step: #2

Next we need to check how the database is configured.

The database needs to be configured with different categories that have columns.

Figure 3 shows an example of database data. If there are 2 different categories of alarms, then the database should have 2 separate columns matching the total number of alarms.

For example: Process Temperature & Output Temperature.

Figure 3

Step: #3

To keep things simple, let’s start with the dataset that comes with the default XY chart when you drag it in from the perspective components window. Figure 4 shows the default XY chart.