Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jan 26, 2023 07:08 AM
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.
Jan 27, 2023 11:57 AM
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:
Feb 02, 2023 06:37 AM
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.
Feb 02, 2023 06:38 AM
The only solution I could come up with, which is frankly ridiculous, is creating another table with rollup fields for every month.