Trend Line

You can only add a Trend Line when you have two continuous fields on opposing axes (one on Rows, one on Columns). The Trend Line can be used to see the trend of a Measure over time or the correlation between two Measures.

To add a Trend Line, drag and drop the option on the View. By default, the Trend Model used is Linear. You can specify the Trend Model to use when you drag and drop the option.

It's also possible to add a Trend Line with a right-click on the View, among the options available. 

Here's an example of the usage of Trend Lines:

As you can see, it's easy to see that the profits are growing for Office Supplies and Technology, but stagnating for the Furniture

When you hover over a Trend Line, you can see some information about the Trend Model. If you right-click on the Trend Line, you can open an advanced description of the Trend Line and the Trend Model or open the Edit Trend Lines... window where you can change the Trend Model and customize it.

For the next option, a Date is mandatory. 

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.191.178.211