Forum Discussion

GlitchedDuck's avatar
GlitchedDuck
Frequent Visitor
4 years ago

Average Count Per Day/Week/Month Card

Hi All,   I'm trying to create a few card visualization that shows average amount of invoices per Day/Week/Month.   In my data i have created_date, Invoice_Number and want to show the average in ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi GlitchedDuck ,

 

Please check the following measures.

_day = calculate(average([invoice_number]),filter(allselected('table'),[create_date] = selectedvalue([create_date])))

_month = calculate(average([invoice_number]),filter(allselected('table'),month([create_date]) = month(selectedvalue([create_date]))))

_week = calculate(average([invoice_number]),filter(allselected('table'),weeknum([create_date]) = weeknum(selectedvalue([create_date]))))

 

Best Regards,

Jay