I have a base where one of my tables is transactions (primary column) where there is a revenue column, date column, and other pertinent information. If I wanted to view revenue by month, that's super simple in views and I could see the average at the top if I changed sum to average. All fine and dandy but if I wanted average monthly revenue in a number element in Interfaces, there seems to be no way of doing that easily. I feel like a grouping or bucket function in the number element settings would make perfect sense but the best I can do now is average revenue per transaction and that's not what I want. Any suggestions welcome.
Do you have a field in your table for "Month"? I have used a formula field to populate this field in the past in order to get the chart I want in Interfaces. Here's the formula:
Yes, I do have a month column but that doesn't help with the number element since you can't group. For instance, if there was 5 transaction in Jan and 6 transactions in Feb, and you wanted to know the average sales volume over both January and February, you wouldn't be able to get the number element to provide that for you. It could only provide an average over the 11 transactions.