[{"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"}]}]
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.
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.
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.
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
).
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.
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.
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
).
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.
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.
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.
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.
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.
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.
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:
Moving annual total average – the trendline consists of data points that are the totals of the previous N
data points. The N
value is specified by the Period
property.
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.