Content Comparison

Whenever you add or remove data fields, or filter data, click Run in the top-right corner to recalculate the data and refresh the visualization. 

Following the example we have been working on, let's take a look at the current visualization.

1. Above the Data, click Visualization to expose the chart.
   

Your chart will update based on two items:

1. What data is listed under the visualization and;
2. How the data is listed.

To demonstrate this concept, let's become familiar with more of the Data controls.

• Section A: Row Limits and other controls. By default, Row Limit only displays the first 500 rows. This is so the system does not overload while attempting to calculate large quantities of data. (You can download data larger than 500 rows into a spreadsheet.) To limit the number of rows a visualization displays, adjust the number here. Note that this does not mean the top information (for example, limiting this to 10 rows does not mean you are seeing, say, the top 10 regions). You are instead seeing the top information based on how the data is sorted across all Dimensions and Measures. See XZZ for more information.
  • Other controls, like Total, Subtotal, 
• Section B: Column Gear Icon. On a Dimension, hovering over a column header shows a menu that helps you control that data field. From here, you can:
  • filter or pivot your data by this data point;
  • hide the data from the visualization the data field, but keep keeps the column data in the Data areachart; or
  • remove the data field altogether, where you would have to go back into the data fields on the left-hand of the page to find it again.
  • You can also fill in missing values whenever you have dates that skip a time frame due to no data (for example, when there is data for January and March but not February, February might be omitted from the data list, which may make your chart look weird. Use Fill In Missing Values to fill in empty dates or other consecutive data to help your charts look better.)
  • Finally, you can copy the values of that column and paste them elsewhere.
• Section C: Sorting. Click any of the column headers to sort the data from lowest to highest, or alphabetically/reverse alphabetically.

Adjusting Data

As you are building visualizations, you will experiment with different data points to help you tell your story. When you add data from the data fields, you have to Run it to update the visualization. However, let's say you want to temporarily hide some data, just to see what it looks like. Going back to our original example with only WO Status and WO Count, you can use the gear to hide Region temporarily:

Controlling Row Limits

Using Row Limits, you can control the number of data rows your visualization, up to 500 rows. This is so the system does not overload while attempting to calculate large quantities of data. 

What is important to note about Row Limits is that it does not automatically calculate the top information (for example, limiting this to 10 rows does not mean you are seeing, say, the top 10 regions). You are instead seeing the top information based on how the data is sorted across all Dimensions and Measures.

Let's start by limiting the rows in our example to 5:

Now, let's sort by a different field, say, Region:

Pairing Down Data

blah

Next Section: Filters and Pivots

Of course, you don't just want to know how many work orders are in each status. You probably want to filter the data to show, say, all Open and In Progress work orders for the past 90 days. For that, let's go to the next section.