To visualize this data you will need to make some choices about what data you want out of the dataset, and how it should be arranged or manipulated.
Do you want to filter the data (e.g. reduce the amount of data viewed)? If so,
choose a column you would like to use for filtering. Once the column has been
selected, you will need to select an operator or how you want to filter (e.g.
equals, does not equal, like, not like, etc.) and then the value for filtering
in the third box. The third box provides a list of unique values found within
the column you are filtering.
In this box, the drop down provides a complete list of options, or you
may start typing in the box to have options provided to you. You may also
filter the data on up to three values. Select "AND" if records need
to meet both conditions. Select "OR" if records need to meet one of
the conditions listed.
Grouping allows you to sum up values in a dataset and create charts, graphs,
and maps. Similar rows are grouped and their values are summed, giving you a
better overview of the data. Grouping data for a table view is optional but is
required for all other visualization types. Although you may group on multiple
columns, not all visualization types will be able to show multiple groupings.
If you choose multiple groupings, a table, bar or column charts are your best
choices. To produce maps, you will need to group by codes that are associated
with a geographic area, such as county code, city number, school district code.
If the dataset can be mapped, a map option will be available to you at the
bottom of the page.
You can sum, average, count, and find the min/max values of numeric columns.
You can choose which columns to display for a table visualization, please choose the columns from the list below. To select multiple items, hold the shift key, to de-select an item or add a single item, hold the CTRL key.
You may choose a column to sort by.
Based on your selections above, the following visualizations are possible. Click on a button to view the visualization.
Contact Us | State of Iowa | Office of the Governor | Department of Management | Policies