Tableau Reference Band – Creating Time Series Graph in Tableau

FREE Online Courses: Click, Learn, Succeed, Start Now!

1. Objective

Before we start let’s see Tableau Reference line. In this Tableau tutorial, we will study about what is Tableau reference band, the various steps in creating time series graph using the reference band in Tableau.
So, let’s start our session on Tableau Reference Band.

Tableau Reference Band

Tableau Reference Band – Creating Time Series Graph in Tableau

2. Tableau Reference Band

Tableau reference band creates a banded or shaded area in a chart and can show if other points fall within a RA in Tableau, we can drag Reference Band from the Analytics pane and drop it onto our view.
If we have different groups in the view, we will be presented with the scope options Tableau, Pane, and Cell. If there is more than one axis, we also have the option of creating the band on one of the axes or both.
Let’s Discuss How to Add Them Constant Line in Tableau
With a reference band, we need to supply the range – the Band From and the Band To value. Before we can select this in the Edit Reference Line, Band, or Box window, we need to make sure the fields for the boundary values are already in the view. If it is not yet there, and it does not need to be placed in a way that affects the overall view, we can place these fields in the Details property in the Marks card.nge or interest or not.

Tableau Reference Band

Example of Tableau Reference Band

3. Create Time Series Graph with Reference Band in Tableau

Following steps guide us to create Tableau Time series Graph with the help of Tableau reference Band:
Do You How to Create a Story Line in Tableau
i. From Dimensions, right-click and drag Created Date DT to Columns and select Discrete Hour:

Tableau Reference Band

Step-1 Creating Tableau Time Series Graph

ii. Right-click on the HOUR(Created Date DT) field in Columns and select Continuous.
iii. Right-click on the HOUR(Created Date DT) field in Columns, and select Format. On the sidebar, under Scale, choose 12-Hour format for Dates:

Tableau Reference Band

Step-3 Creating Tableau Time Series Graph

iv. Right-click on the Created Date DT axis to edit axis. Change the axis title to # Complaints.
Read about Tableau Trend Line in detail
v. From Measures, drag Number of Records to Rows.
vi. Edit the Number of Records axis and change the axis title to Complaint Time.
vii. From Dimensions, drag Descriptor (group) to Color in the Marks card.
viii. On the sidebar, click on the Analytics tab to activate it.
ix. Under Custom, drag Reference Band from the Analytics tab and drop it onto Table in the HOUR(Created Date DT) placeholder:

Tableau Reference Band

Step-9 Creating Tableau Time Series Graph

x. In the Edit Reference Line, Band, or Box window, use the following settings:

  • Scope is Entire Table
  • Tableau Reference Band From Value is From Time
  • Reference Band From Label is Custom, and type in 8 AM
  • Band To Value is To Time
  • Band To Label is Custom, and type in 5 PM:
Tableau Reference Band

Step-3 Creating Tableau Time Series Graph

xi. Click OK when done.
Let’s Explore Tableau URL Action – How to Create URL Action
xii. Right-click on the Reference Band and select Format.
xiii. Set the Alignment for the Reference Line Label to top.

This was all Tableau Reference Band Tutorial. Hope you like our explanation of Creating Time Series Graph with the help of Reference Band in Tableau.

4. Conclusion

Hence, in this tutorial, we studied what is reference band in Tableau and how to create the time series graph with Tableau Reference Band. Furthermore, if you have any query feel free to ask in a comment section.
Related Topic- Tableau Parameter Tutorial 
For reference

If you are Happy with DataFlair, do not forget to make us happy with your positive feedback on Google

follow dataflair on YouTube

Leave a Reply

Your email address will not be published. Required fields are marked *