Give a chestnut! Tableau Tips (21): Easily use parameters to achieve data growth analysis
When using a spreadsheet for data growth analysis, you need to add a field to the actual comparison result in the table, and then use the function to calculate the analysis result. Then, the resulting analysis results are then graphed, which is often half the battle.
And, if your data is not an excel file, but a data in a system or database, and the amount of data is very large, things are not that simple.
How can I easily implement data growth analysis?
In fact, in Tableau, you only need to use one parameter.
thisThe “Take a Chestnut”, Ada’s Tableau technique to share with you is: easy to use parameters to achieve data growth analysis.
The chestnut is used as an application scenario to realize the year-on-year growth of data.Specific steps are as follows:
Step 1: create date parameters
Step 2: create a calculated field
Step 3: pull the analysis dimension to the worksheet
Drag the dimension you want to analyze to the worksheet and start analyzing the year-on-year growth. For example, if you want to analyze the year-on-year growth of 2016 products, you can get the following analysis results.
Thus, a year-on-year growth analysis of data is completed. Is not it simple? Quickly open your Tableau and give it a try!