Aggregate data in Calculation View
I was trying to create a create a calculation view with aggregated data, for example Car dealers and the total number of cars sold in a month.
So I need to group by dealer and get the count of cars that are sold.
I want to create a graphical calculation view. When I use aggregation node I can see only sum, max & min.
How can I get count or avg function?
Expecting a response.