This template is used for reports where you want to compare the trend of two accounts Accounts in two categoriesCategories. The break-down of the two accounts per entity 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 Short Term Receivables are slowly going up with some relapse. The trade receivables days Trade Receivables Days on other hand are going down. A conclusion you can draw from this is that the average outstanding receivables Average Outstanding Receivables is getting bigger. Also the difference between actual Actual and budget 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 Budget targets.
What is viewed in this example?
- This chart combines a bar and a line chart for the current and previous 12 months for two categoriesCategories. The bar chart is a fixed account Account and the line chart is a variable account Account based on an account Account list. You can change the variable account Account or KPI by clicking on the account Account name (1A). When you click on one of the bars or of the line in the chart you change the current period into that period for the entire report. In the business Report settings you can change the account Account list, the fixed accountAccount, the time period you look back at and the displayed categoriesCategories.
- The top bar chart on the right breaks down the variable account Account (1A) by entity 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 Entity hierarchy.
- The bottom bar chart on the right breaks down the fixed account Account by entity 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 Entity hierarchy.