[{"id":"bf522b5c-b992-4910-b9a3-7d4c6a711342","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"fd92c740-60f2-42bc-b108-133c0baaec15","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"1809c8ed-488b-4fb9-b402-aabe76f0c6d2","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"8aa13734-ff9b-43f5-b44f-de331adbb3d7","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"8faaa45c-575e-4bf0-9034-634fac906bb8","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"56faca6f-14d3-42b0-9706-7df8e339ef70","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"eb780c12-7575-42ef-916d-9d1d66cd0152","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"3918314b-5267-494d-b520-203125daf2a2","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"97d3eeb1-76c4-4c11-bc62-db5413d6819f","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"e93f9124-e327-4056-9264-f62378c3ebb5","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"90683712-67eb-49c8-96cb-96a228a99d11","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"cf1d42c1-fe4a-4f31-83f7-97c9c7ea9b76","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"e6222e08-3705-44f2-9027-b80b72dd3a85","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"5f8d0a4e-e3c5-4f38-91ee-c0d4aa8f116d","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"1ab019cd-705f-4371-a3f3-f2925cf92826","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"2ebee074-0c53-44bf-89c4-c0deb0d210f7","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"488a368a-fad1-4022-8e64-03442a912d2c","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"9aa35d28-77db-4dbd-ade0-17163a1782be","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"5a8c2832-0b00-47dc-aa9c-2579f4d9e04c","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"c19b5fcc-8f2a-4f44-9eeb-345cbb4815a6","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"92556861-b9b0-454e-a493-4750e9d90d2c","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"5ca1a599-fa29-4d8a-8cb4-80352932149f","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"7a947fc6-0187-4b9d-b9cc-800def67c597","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"b74ce673-ba64-42ea-b124-fc006b6b727e","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"a201d71e-7541-4e64-ac8b-3ed714e41a81","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"9efb31b1-f5f2-4214-a36d-c3415649a7a0","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]}]
        
(Showing Draft Content)

Chart Overlays

Overlays

In addition to geometrical shapes, such as columns, bars, or lines, that represent the data, a plot can contain additional items, called overlays, that represent the meta-information about the data. A typical example is a trendline that shows the linear regression of the data, as in the picture below.


image.png


You can add an overlay by selecting a plot and editing its Overlays collection in the Property Inspector.

All overlays has the following common properties:

  • Name – the name of the overlay

  • Type – the type of the overlay

  • Display – the Front value indicates that the overlay displays on the front side of the plot, the Back value indicates that the overlay displays on the back side of the plot

ActiveReportsJS chart supports several overlays types that we describe in detail below.

Reference lines

You can use Reference lines to display the data value at a given point. For example, the chart below has the reference line at the y-axis at the value that corresponds to the average sales amount for each sales channel.


image.png


A Reference line overlay exposes the following specific properties:

  • The Line Properties set the appearance of the reference line.

  • The Axis property specifies the axis with which the reference line is associated.

  • The Value property specifies the value of the reference line on the selected axis. You can use for static values.

  • The Field property specifies the data value on the selected axis that the reference line is associated with.

  • The Aggregate type property specifies the aggregation type that applies to the Field to calculate the value of the reference line.

  • The Legend Label property specifies the text that appears in the legend and associated with the reference line.

  • The Detail Level property specifies whether the reference line appears once per plot(Total) or once per detail encoding instance(Group).

Reference bands

You can use Reference bands to display a range of data values between given points. A Reference band overlay exposes the following specific properties:

  • The Line Properties and the Background Color set the appearance of the reference band.

  • The Axis property specifies the axis with which the reference band is associated.

  • The Start and End properties specify the start and the end values of the reference band on the selected axis. You can use for static values.

Linear trendlines

You can use Linear trendlines to display the best fit straight line that shows how data values increase or decrease at a steady rate. For example, the chart below has a linear trendline that shows the trend of the sales amount over three consecutive years.


image.png


A Linear trendline overlay exposes the following specific properties:

  • The Line Properties set the appearance of the trendline.

  • The Intercept property specifies the point where the trendline should cross the Y axis. You can use it for static values.

  • The Forward Forecast Period and the Backward Forecast Period properties specifies the number of data points for which the trendline extends forward and backwards relative to the last and the first data values, respectively.

  • The Field property specifies the data value with which the trendline is associated.

  • The Legend Label property specifies the text that appears in the legend and associated with the trendline.

  • The Detail Level property specifies whether the trendline appears once per plot(Total) or once per detail encoding instance(Group).

Exponential trendlines

You can use Exponential trendlines to display the best fit exponential curve that illustrates how data values increase or decrease and then level out. This trendline can only be used with data values that are greater than zero. A Exponential trendline overlay exposes the same properties as the Linear trendline overlay.

Power trendlines

You can use Power trendlines to display the best fit curved line to compare measurements that increase at a specific rate. This trendline can only be used with data values that are greater than zero. A Power trendline overlay exposes the same properties as the Linear trendline overlay, except for the Intercept property.

Logarithmic trendlines

You can use Logarithmic trendlines to display the best fit exponential curve that illustrates how data values increase or decrease and then level out. A Logarithmic trendline overlay exposes the same properties as the Linear trendline overlay, except for the Intercept property.

Polynomial trendlines

You can use Polynomial trendlines to display a best fit a curved line illustrating fluctuations in data values. For example, the chart below has a polynomial trendline that shows the trend of the sales amount over months.


image.png


A Polynomial trendline overlay exposes the same properties as the Linear trendline overlay. The Order property that has valid values from 2 to 6 indicates the complexity of the equation that defines the polynomial trendline.

Fourier series trendlines

You can use Fourier series trendlines to display a best fit Fourier Series line that illustrates fluctuations in data values. A Fourier series trendline overlay exposes the same properties as the Linear trendline overlay. The Order property that has valid values from 2 to 6 indicates the complexity of the equation that defines the Fourier series trendline.

Moving average trendlines

You can use Moving average trendlines to display a line that smooths out fluctuations in data values to show a pattern or trend more clearly.


ActiveReportsJS supports the following moving average trendline types:

A Moving average trendline overlays expose the following properties.

  • The Line Properties set the appearance of the trendline.

  • The Field property specifies the data value with which the trendline is associated.

  • The Legend Label property specifies the text that appears in the legend and associated with the trendline.

  • The Detail Level property specifies whether the trendline appears once per plot(Total) or once per detail encoding instance(Group).

  • The Period property that has valid values from 2 to the amount of data values indicates the number of data points used to calculate the moving average.

For example, the chart below has a simple moving average trendline with Period = 2 that shows the trend of the sales amount over months.


image.png