I am trying to plot the average transaction count and total value per calendar month (e.g., we average 20 transactions, and $100M, in September each year) in a bar chart from a table that has the date and value of each transaction.
Say I have the following table that has the date and value of each transaction (only showing transactions from last and current September for simplicity):
With this data, we average 2 transactions, and $250.00, each September.
I created a master dimension on calendar month ([Txn Month]), which is just Jan, Feb, Mar, etc.
I added a bar chart.
I set the dimension to [Txn Month]. I don't know how to express either measure. Based on what I found on this forum, I tried using
Avg(Aggr(Sum([Value]), [Txn Month]))
Avg(Aggr(Count([Value]), [Txn Month]))
but nothing shows up in the bar chart other than the [Txn Month] axis dimension values. (No bars show up for either measure.) I tried adding just the Aggr() expressions to tables to see what was in there, but nothing displayed.