This lesson is part of the Reporting in Ignition course. You can browse the rest of the lessons below.

LESSON LIST

Autoplay Off

Description

Let's take a closer look at the Reporting module's Bar Chart component

Video recorded using: Ignition 8.1

Transcript

(open in window)

[00:00] The bar chart component helps to represent our data as bars. It's a fairly easy component to configure and it has many customization options. Just like the previous lessons, I'm here the design tab for my report. Let's start by dragging and dropping a bar chart component onto my report. The first thing we need to do is set the data key, so we'll take a look at our key browser. I have this bar chart data under data sources. I'll drag and drop it down in the data key. I'm going to do this one more time because I want to show you a very important property on the bar chart, that property being this extract order. I'm going to set the second chart to extract by column. My first chart is using the default option, which is row. Let's head over to the data tab to get an idea of what our data looks like. You'll see I have a static CSV here and there's three columns. The first is category, which list a couple of months, and then we have our values for our north and south areas. When we switch to the preview tab, you can see how these two extract orders differ. When you extract by row the category or the way the bars are grouped up is determined by the first column, which in this case would be my category column.

[01:15] As you can see, this is why my items or bars are grouped by month. Each item is a separate column in my data source. So we have north area and south area. When the extract order is set to column, my items are grouped by the second and third column where each item is determined by that first column. Now let's take a look at some of the other properties on a bar chart. I'll head back to the design tab and I'll select my top bar chart. I'll head down to the property inspector and I'll make it floating just so it's easier to see everything. In the configure tab aside from extract order, you can make your bars 3D bars, or you can turn the chart into a Pareto chart. We'll take a look at some of the properties on that later. You can also change the rendering style. Instead of bars, you could do stacked or layered. We'll leave it at bars for now. You can change the segment colors or you can add additional segments for when you have a lot of bars on your chart.

[02:06] There's also the scripting event down here that allows you to make any sort of modifications to the chart before it's rendered. Next we'll take a look at the properties tab. You'll see there are even more properties for us to tweak. We can change the category margin, which is the space between each category. So if we change it to 0.5, we'll see that the items did resize. They're a little bit skinnier now, but that's to make more room between each category. Additionally, we can add some space between each item with the item margin property. I'll set this back though. If we scroll down, you'll see a couple more options for a Pareto chart. So we can hide or show that 80% line, or we can change the label on the Pareto series. We'll set the Pareto option back to false for now though. Here's some axis options, so we can turn auto range on or off. We can change what the high and low is for when auto range is off. The bar labels property will put a number on top of each bar, so we can very easily see the value of each bar.

[03:03] You can also change where the label appears on the bar, so if you want it a little bit lower, you could set it to negative 20, for example. And below the label options you'll see basic properties, so height, width of the chart, and so on. So as you can see, there are many different properties on the bar chart that greatly impact how the data is presented.

You are editing this transcript.

Make any corrections to improve this transcript. We'll review any changes before posting them.