Creating a Time Series visualization

In this article, you will learn to create a time-series visualization.

Introduction:

A time-series visualization lets you display data points at successive intervals of time. Each point on the chart corresponds to both a time and a quantity that is being measured. Time series charts visually highlight the behavior and patterns of the data. They allow you to easily identify patterns like trend, seasonality, and correlation.

Time series visualization types available through the Impact Cloud V3 include  Line, area, bar, and scatter plots charts. 

Let's  illustrate it with an example:

Let's assume, you would like to understand the total number of scholarships awarded each month.

Step 1.  In Impact Cloud v3, to create a chart click on the Chart tab from the Home screen.  You can alternatively click on the + symbol to open the Chart submenu and click on Chart to create one.

Step 2. For this example, select the following

Dataset:demo_scholarship_data 

Popular charts or All Charts: Time-series line Chart

Finally, click on Create New Chart at the bottom right-hand side.

Time-series Line Chart

Step 3.  On the chart canvas, select the following as shown below:

in Time: 

Time Column: Actual date

Time Grain: Month

In Query:

Metrics: count(*)

Step 4.  Once the attributes are set for Time and Query, Run the Query. The below visualization should appear.

 

Step 5.  Now you can save the chart  as  "Scholarship Awarded Monthly" to the Dashboard

Try the following in the same chart created above with some changes as below:

in Time : 

Time Column: Actual date

Time Grain: Year

In Query :

Metrics : count(*)

Note: This chart will help you understand the difference between Time Grain: Month & Year.

 

Time-series Bar Chart

To understand this chart, let's take an example to understand Scholarship Awarded yearly.

Step 1. Click to create a new Chart.

Step 2. For this example, select the following as shown below: 

Dataset: demo_scholarship_data 

Popular charts or All Charts: Time-series Bar Chart v2

Finally, click on Create New Chart at the bottom right-hand side.

 

Step 3.  On the chart canvas, select the following as shown below:

Visualization Type: Time-series Bar Chart v2

in Time: 

Time Column: Actual date

Time Grain: Year

In Query:

Metrics: Scholarship Awarded

Step 4.  Once the attributes are set for Time and Query, Run the Query. The below visualization should appear that shows the total amount of Scholarship Awarded each year. You can save this chart too.

Congratulations !! You have learned to create a Time-series chart too.

Similarly, you can create Time-series Area Chart by changing the Visualization Type to "Time-series Area Chart" and changing the Time Grain to Day, Month, Year as per your use-case. You can select other Query attributes to suit it.