Forum Discussion
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 ...
Have you a date table linked to your Invoice Header? The Date part of the measure I provided needs to be passed through the date table and not the fact table. Hence why you're getting everything. It provides the context for the average.
I have a Date_Dim table thats joins to my Invoice_Table and it shows the same results. I can do an actual count by day with no issues, but when i add the average it gives me a total count of invoices