Dashboard for WinForms - How to display best and worst monthly sales for each year

This example shows how to display the highest and lowest monthly sales for each year.

Example Structure

In this example, the Chart dashboard item shows yearly sales numbers.

To display the highest/lowest monthly sales for each year, the following expression is used:

aggr(Sum([Sales]), GetYear([OrderDate]), GetMonth([OrderDate]))

Files to Review

• Form1.cs (VB: Form1.vb)

Documentation

• Intermediate Level Aggregations
• Aggregations
• Expression Constants, Operators, and Functions

More Examples

• Dashboard for WinForms - How to calculate Highest Product Sales by Year
• Dashboard for WinForms - How to Calculate the Contribution of Quarterly Sales to Total Yearly Sales
• Dashboard for WinForms - How to evaluate a customer acquisition using the quarter/year of their first purchase
• Dashboard for WinForms - How to divide customers' count by the number of orders they made
• Dashboard for WinForms - How to display sales by years in comparison with the previous year's sales
• Dashboard for WinForms - How to Display Product Sales that are Greater than $20k
• Dashboard for WinForms - How to Display Products with Sales Greater than Average Sales per Category