Trends

This template is used for reports that give insight into the variance between two Categories for an Account. The report shows the Variance trend and a breakdown of the Account into one analytical dimension. It also gives the ability for a further breakdown of the Account by any analytical dimension.

What is viewed in this example?

1. The top left bar chart gives a 12 month trend of an Account for two Categories. Usually these Categories are Actual and Budget, but this can be changed in the Report settings. On opening, the bar chart is set to show the 12 month trend. By clicking on Periods (1B) you can change a 12 month trend into a 12 months trend within the current year. By clicking on one of the bars you determine the time period for the two bar charts on the right. You can change the account, which is based on an account list, by clicking on the pick list behind it (1A). In the Report settings you can change the Account list. You can also select the compared Categories from the pick list (1C).
2. The lower bar chart in the main screen shows the Variance.
3. You can toggle between a variance in percentages and absolute values
4. The bar chart in the top right gives a breakdown into the direct descendants of one of the analytical custom dimension for the selected account (1A) and the two Categories selected in 1 in the current period.
5. The lower right bar chart shows the Variance between the two Categories selected in 1C for the selected breakdown and the current period.