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

LESSON LIST

Autoplay Off

Description

The CrossTab Table component allows you to show groupings in a matrix based on two keys. You can easily create a visualization of interactions between multiple keys.

Video recorded using: Ignition 7.9

Transcript

(open in window)

[00:00] The CrossTab component allows you to very quickly show cross sections of data. Where the other tables are focused on a dynamic number of rows and columns, the CrossTab allows you to show a matrix based on groupings between two keys. If we take a look, I already have a CrossTab component dropdown on my report. And I already set the data key to this Downtime_By_Site data source. If we take a look at that, we'll go to the Data panel. And we'll see it's just a static CSV, just showing Equipment, Time, and Site. Now I want to use the CrossTab to show you a count between the number of Downtime events for each piece of equipment and each site. I have four different sites, Site A, B, C, and D, and the four pieces of equipment we've been using. Begin by going back to the Design panel. We'll select the CrossTab, click and drag the Equipment key, and drop it on the top row here. Then we'll grab Site and place it in the first column over here. Lastly, we'll grab Count and put it in the remaining set. What this is going to do is give us a count based off of the equipment and the site of each row in our data source. If we take a look in the Preview panel, you'll see each piece of equipment in each site. Now let's compare this to the raw data. For example, our Motor has two occurrences at Site A. If we take a look at the Data panel, we'll see we have two rows with Motor and Site A. Let's add another key. We'll go back to the Design panel, and we'll add a new row. With the CrossTab selected, we'll take a look at this row's property. We'll change that to two. We'll go and double-click on the divider here and then drag this down to give us a little more room. And let's take a look at the total time per piece of equipment. We'll come over here to our Time key, grab a total, and we'll drag and drop it down below Count. Next, we'll select the cell and increase the font. Now, over here, I'm not going to put a key, but instead I'm just going to go ahead and put a header. I'll type Total Time. Again, I'll change the font. If we take a look at the Preview panel, you'll see we have this Total Time row now. Now this only looking at the total time per piece of equipment. It's not grouping up against a site. It's only grouping against a single key, Equipment in this case. We're looking at the total time for all of our motors in our data source. We can go ahead and make sure that this is doing what we think it is. We'll take a look at the Palletizer. It has a total of 70 down below. We'll take a look at the Data panel. You'll see there are only two rows in our data source with Palletizer as the Equipment, one for 40 and one for 30 so that equals 70. You can very quickly and easily use the CrossTab to show interrelation between two keys.

You are editing this transcript.

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