Compare Trend

This template is used for reports where you want to compare the trend of two Accounts in two Categories. The break-down of the two accounts per Entity gives you the ability to analyze a potential trend.

If you look at the example below you can see that the Short Term Receivables are slowly going up with some relapse. The Trade Receivables Days on other hand are going down. A conclusion you can draw from this is that the Average Outstanding Receivables is getting bigger. Also the difference between Actual and Budget is small on consolidated level you can tell by the bar charts on the right that for instance Europe has some problems meeting the Budget targets.

What is viewed in this example?

1. This chart combines a bar and a line chart for the current and previous 12 months for two Categories. The bar chart is a fixed Account and the line chart is a variable Account based on an Account list. You can change the variable Account or KPI by clicking on the Account name (1A). When you click on one of the bars of the line in the chart you change the current period into that period for the entire report. In the Report settings you can change the Account list, the fixed Account, the time period you look at and the displayed Categories.
2. The top bar chart on the right breaks down the variable Account (1A) by Entity for the current month. When you click on one of the bars in the chart the whole report drills down one level in the Entity hierarchy.
3. The bottom bar chart on the right breaks down the fixed Account by Entity for the current month. When you click on one of the bars in the chart the whole report drills down one level in the Entity hierarchy.