Requires Memento Database 5.0 or newer
Aggregation widgets are a type of widget in Memento Database that provide a quick way to display summarized data. To add an aggregation widget to a dashboard, simply click on the Add Widget menu item in the dashboard’s menu and select the Aggregation option. From there, you can select the library and field you want to summarize, and choose the type of aggregation you want to use (such as sum, min, max, or average). You can even select multiple aggregation functions and fields in one widget.
By displaying summarized data in a clear and concise format, aggregation widgets can help you understand the overall picture of a particular data set. For example, you could use an aggregation widget to compare total sales across multiple regions or to track changes in monthly expenses over time.
In addition to the basic settings mentioned above, Memento Database also provides extra settings for all types of widgets, including aggregation widgets. These additional widget settings are available on different tabs:
- Filter: You can set a filter for the data that will be used for aggregation. This allows you to narrow down the data set to a specific subset of records based on specific criteria.
- View: You can set up the font for the text displayed in the widget, as well as select how to display the aggregation for multiple functions.
- Action: You can choose the action to perform when the widget is clicked. There are multiple options available, such as opening a library, creating an entry, or running a script. This allows you to customize the widget’s behavior and make it more interactive.
In summary, Memento Database Dashboards provide a powerful tool for comparing and visualizing data from multiple sources, and aggregation widgets are just one of the many widgets available to help you do so.
Here are some examples of how you can use aggregation widgets in Memento Database dashboards:
- Sum of expenses: Let’s say you have a library where you record your expenses. You can create an aggregation widget that shows the sum of your expenses for a particular month or year. This can help you understand your spending patterns and make better financial decisions.
- Maximum temperature: Suppose you have a library where you record daily temperatures. You can create an aggregation widget that displays the maximum temperature for each day over a period of time. This can be useful if you want to analyze weather patterns or plan outdoor activities.
- Average grade: If you are a teacher, you can create an aggregation widget that shows the average grade of your students for a particular assignment or exam. This can help you identify areas where your students are struggling and adjust your teaching approach accordingly.
- Total sales: If you are a business owner, you can create an aggregation widget that shows the total sales for a particular product or service over a period of time. This can help you track your revenue and identify trends that can inform your business strategy.
These are just a few examples of how you can use aggregation widgets in Memento Database dashboards. The possibilities are endless, and you can customize your widgets to suit your specific needs and goals.