Forum Discussion
How to get the Overall Avg Daily Projects
Hi, what would be the "count" value? measuring using the project name? apologies, I forgot to mention that I have an "Asset Count" value per column to distinguish unique values, I would like to use the "Asset Count" to get the average per day. Does this make sense? thank you!
| Project Name | Date Received | Asset Count |
| Project A | 1 Jan 2023 | 1 |
| Project A | 1 Jan 2023 | 0 |
| Project B | 1 Jan 2023 | 1 |
| Project C | 2 Jan 2023 | 1 |
| Project D | 1 Jan 2023 | 1 |
Solution Supplier
Correct, the count is based on the project name as based on your explanation, you are trying to find how many unique (I assume) projects there are on a given day in the first instance, before finding the average.
If you want to factor in asset count, you just need to bring this into the "Count" expression: Calculate(distinctcount([Project Name]),[Asset Count] = 1)
Thank you, this does provide a numerical result but still unsure since the result value doesn't match the excel results using the same data. Just one last question, how would it look like if we don't consider the distinct count since I have an asset count already that gets the unique value? so just getting the average daily projects using the overall total asset count vs dates. thank you so much!