Getting started with Aico
- Logging into Aico for the First Time
- Creating your first journal
- Creating your first request
- Creating your first payment
- Creating your first Intercompany Invoice
- Working with Closing Tasks
Working with Journals
- An overview of Aico journals
- How to create a manual journal
- Create a journal by copying existing journals
- Import new journals from Excel
- How to import multiple journals from one Excel spreadsheet
- What are recurring journal entries?
- How to create Recurring Duplicate Journal entries
- How to create Recurring Allocation journal entries
- Create recurring journals with automatic reversals
- Reversing documents
- Import data to existing journals
- Export journals to e-binder
- Working with Reconciliations
- Basic settings in Aico documents
- Excel Support
- An overview of Aico Dashboards and Lists
- How to use lists in Aico
- How to use dashboards in Aico
- How to use charts in a dashboard
- Dashboards: Advanced Settings
- Closing Tasks
- Users and User Groups
- Value sets
- Currency Amount Groups
- Mail notifications
- Tax codes
- Introducing Automation Manager
- Core Set Up
- Introducing task templates
- Creating task template details
- The Aico Document
- Aico document headers
- Preparer and Approver workflow settings
- Overriding parameters at a company level
- Master data export and import
- Set a custom schedule
- Dependent tasks in Aico
- How to use Smart tags in Aico
- How to add an attachment to a task template
- Task Generation
- Administrative tasks
- Aico Announcements
Modified on Thu, 24 Nov 2022 at 02:47 PM
Line charts work well if you want to see how values change over time.
For this article, we will create a vertical bar chart that shows the number of completed account reconciliations by period in the Account Reconciliation dashboard.
Open the Account Reconciliation dashboard and click on the cog wheel in the top left corner.
If you do not have a cog wheel in the top left corner, you do not have Shared Dashboard Admin rights. In this instance, you will need to copy the dashboard. Once copied, you will see the cog wheel in the top left corner. Click here to read the article that shows you how to copy and personalise a new dashboard.
Click on Add chart at the bottom of this section.
1. Name your chart.
2. Choose Line chart from the Type drop-down.
3. From the Category field, choose Period.
4. From the Value field, choose Account name.
5. As you want to count the number of completed documents, set the Aggregate function to count.
6. If you want the axes to be labelled on your chart, tick the boxes.
7. Click the Refresh arrow to see your line chart.
The chart will display the available data. In the example below, you can see not all the periods had data, so they do not show on the chart.
Click Save on your dashboard to save the chart.
Adding a Filter
The next thing we can do, if we are only interested in the number of documents not completed in a specific period, is to filter the chart so it only shows documents which are not completed.
8. Click on the + sign to the right of Filters.
9. Scroll down the drop-down list until you get to Not completed.
Save your entire dashboard.
Was this article helpful?
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
We appreciate your effort and will try to fix the article