Properties Menu - Trend Lines

From the 4.1 version of Vitara Charts, trendlines are introduced in Grid Chart. This feature helps in converting the grid chart to micro chart.
Below is the screenshot of trendlines in the grid chart.
trendlinesSample

Inputs

Attributes: 2 or more
Metrics: 1 or more
In the Grid chart, the trendlines are always applied for the second level grouped attribute in the chart irrespective of the number of attributes. And that attribute is called the ‘trend by’ attribute.

To use trendlines in a grid chart, the grid should be either in grouped mode or pivoted. To know about Grouping and Pivoting in Grid chart, click here

There are three types of trendlines in the Vitara Grid chart. They are

  1. Line Chart
  2. Bar Chart
  3. Bullet Chart

Steps to apply trendlines

Step 1

Create a Grid chart with a minimum of 2 attributes and 1 metric. Drag an attribute with which you have to create groups into the Group dropzone.
Below is the screenshot of a grid chart with 3 attributes and 2 metrics and the groups are created using the ‘year’ attribute.
trendlines1

Step 2

Hover onto a metric [Revenue metric in this case] for which the trendlines need to be applied so that the hamburger button will be displayed. Click on the hamburger button, then a menu will be opened.
Hover the mouse onto ‘Display as’, then a submenu will be opened which has the trendline charts. See the screenshot below:
trendlines2

Step 3

Click on the trendline of your choice on that menu. For example, we will click on the ‘Line chart’ here. Then the trendlines for the ‘Revenue’ metric looks the below way. See the screenshot.
trendlines3
If you have noticed the above screenshot, the ‘Category’ attribute got grouped automatically after applying trendlines for a metric. This is because the trendlines are always applied for the second attribute in the chart.

Unsetting the Trendlines:

After applying trendlines for metrics, we can remove them using the below steps.

  1. Open the hamburger menu of the metric in which trendlines need to be removed.
  2. Hover onto ‘Display as’ and wait for the submenu to open.
  3. Click on the list item ‘value’. See the screenshot below.

trendlines4
Then the trendlines will be removed for that metric and value will be shown as in the screenshot attached in Step 1.

Formatting the Trendlines:

In Grid chart, we cannot simply apply trendlines but we can also format them. We can format the trendlines according to the type of chart applied.

To go to the trendlines format window, apply trendlines for a metric and open its hamburger menu. Hover on to ‘Display as’ and wait for the submenu to open up. Click on ‘more options’.
See the screenshot.
trendlines5

When you click on ‘more options’, the below window will be opened.
trendlines6

In the above screenshot, Trend Line Options for dropdown allows you to select a metric on which you need to apply trendlines.
And Chart Type dropdown allows you to select a trendline chart for a particular metric selected in the above dropdown.

Let us look into chart-wise formattings

1. Line Chart
For Line charts, we can format the line color and the final spot color.
To start with, first apply the ‘Line Chart’ trendline for a metric and open the format window. Then set line color (e.g, red) and also the final spot color (e.g, blue). Click on ‘Apply’.
See the screenshot below with applied formattings.
trendlinesSample

2. Bar Chart
For Bar charts, we can format the bar colors and negative bar colors. To start with, first apply the ‘Bar Chart’ trendline for a metric and open the format window. Then set Bar color (e.g, green) and negative color (e.g, red). Click on ‘Apply’.
See the screenshot below with applied formattings.
trendlinesSample

3. Bullet Chart
For Bar charts, we can format the bar colors and negative bar colors. To start with, first apply the ‘Bullet Chart’ trendline for a metric and open the format window. Then set Actual color (e.g, green), Target color (e.g, red) and 3 band colors (e.g, blue, yellow and aqua). Click on ‘Apply’. See the screenshot below with applied formattings.
trendlinesSample