TAX DATA DASHBOARD
This Dashboard includes 2 tiles:
- Year over Year is a line chart showing Tax over Data Years for the filtered Region(s).
- Tax Table is a table chart showing Tax over Data Years.
When viewing a Dashboard, use the filters to change the data points displayed. Filter options include:
- Dollar Type: Real by default
- Data Year: Most recent by default
- Dollar Year: Current year by default
- Region Type: State by default
- State: by default North Carolina, South Carolina, and Georgia
- County: no county filter is set by default
The gear in the upper right provides more options such as downloading the Dashboard to a PDF. On each tile, click the Table Menu (a series of three vertical dots that appears in the upper right of a tile when hovering over it with your cursor) for the option to download the data within that tile. Choose “Explore from here” within the Table Menu to access more data query options. Exploring from the Dashboard allows you to dig into the data starting from the settings within the Dashboard tile.
EXPLORING TAX DATA
Explore the Tax Data by choosing Tax Data from the Explore dropdown menu, or by choosing “Explore from here” from an Tax Data Dashboard Tile or Look.
By default in Explore > Tax Data, the Dollar Type is Real, the Dollar Year is the current year, and the Data Year is the most recent Data Year. With this setting, all dollar values included in a data query will be adjusted for inflation and displayed in current year dollars. It is recommended to always either filter or pivot on Data Year. Otherwise, data measures will be summed over Data Years. Region Type is by default State. Data queries will include State level tax data with this setting.
EXPLORE: FILTER-ONLY FIELDS
Dollar Type
When Dollar Type is Real, Nominal dollar values are adjusted for inflation/deflation such that each dollar value Measures will be displayed in the selected Dollar Year(s). Dollar Year only applies when Dollar Type is Real.
When Dollar Type is Nominal, dollar value Measures will be unadjusted, therefore they will be displayed in the same Dollar Year as the Data Year.
Region Type
View State level taxes by choosing State as the Region Type. Choosing County as the Region level will list County level taxes in the query.
EXPLORE: DIMENSIONS
Select a Dimension to include as a column with all Dimension possibilities. Filter a Dimension to specify which Dimension possibilities appear in the data query. Pivot a Dimension to transpose the Dimension rows into columns.
Dimensions |
Details |
|
County |
All U.S. counties are possible Dimensions. When states are selected in the State filter, only counties within the filtered states will appear in the county filter or in the data query when selected. |
|
Data Year |
All IMPLAN Data Years are possible Dimensions. |
|
Description |
All tax descriptions are possible Dimensions. |
|
Dollar Year |
Years 1997 through 2060 are possible Dimensions. Dollar Year only applies when Dollar Type is Real. When Dollar Type is Real, Nominal dollar values are adjusted to be in the selected Dollar Year(s). When Filtering by multiple Dollar Years, select or pivot on Dollar Year to prevent potential double counting. |
|
Five Digit Fips |
A Five Digit Fips is a county code. The first two digits indicate the state and the following three digits indicate the county. All U.S. Five Digit Fips codes are possible Dimensions. This Dimension is used to map the data in the County View Map Chart found on the Dashboard. A list of FIPS codes can be found at the following link: https://www.census.gov/geographies/referenc |
|
Region |
All 50 States plus the District of Columbia are possible Dimensions. Pivoting or selecting Region will display filtered states when filtering on state and will display filtered counties when filtering on county. |
|
State |
All 50 States plus the District of Columbia are possible Dimensions. |
|
Unit of Government Name |
The Unit of Government indicates the recipient of the tax. Possible Dimensions are region specific. |
EXPLORE: MEASURES
Measures are displayed based on Dimension settings. Select a Measure to include as a column in the data query.
Measures |
Details |
|
Tax |
Tax dollar value. |
Related Articles
Written November 16, 2020
Comments
0 comments
Article is closed for comments.