Transaction data average for count...not dollar value

[unclejemima]

I've got a report where I have transaction data in dollars, each line shows a transaction, the time and the dollar amount...and I'm using the report to instead show a count of the transactions by changing the way the values are calculated with the values dropdown in report.

This is great for daily...but I'm trying to get an average count over a month range...

I'd imagine I have to make a new column that will count the transactions per date and then I can average it?

Advice please 🙂

[v-xjiin-msft]

Hi @unclejemima,

Sorry, but I'm not quite understand your requirement. Could you please share us more detailed information about your requirement if possible? Like your source table structure and some sample data. So that we can make some test about your issue and provide a proper solution. Also please attach your desired result, it'll give us the right direction. 

Thansk,
Xi Jin.