Multiple group aggregates

[Jayed_Hasan]

I want to show the daily, weekly and monthly sales data such as total number of orders, average order value, total sales amount. This can easily be done if there were options to show multiple group aggregates. But since there's no such option right now I think making virtual columns for each data and showing them in table or chart view can be an option. I'm struggling to make the virtual columns. For example, a virtual column for how many orders are generated based on a particular date. Another column for the sum of all order values on that date and so on.