User Profile
GaryO
Frequent Visitor
Joined 9 years ago
User Widgets
Contributions
Re: Average of a monthly count of non numeric values
Sean Nearly! There aren't a full twelve months though. I think i need to do something around the latest month minus the earliest month. The results I'd expect based on the data above are below: Subject CaseNumber_Count MonthYear_Count MeanAverage_Month Area Maintenance Request - Fly-tipping 7 5 1.4 Area Maintenance Request - Road Sweeping 1 5 0.2 Council Tax Bereaved Single Person Discount Request 1 5 0.2 Council Tax Change of Address Request 5 5 1 Council Tax Empty Property Discount Request 1 5 0.2 Council Tax Enquiry 10 5 2 Council Tax Landlord Change of Tenant Request 2 5 0.4 Council Tax Single Person Discount Request 5 5 15.8KViews0likes1CommentRe: Average of a monthly count of non numeric values
Here you go: So I wish to get a mean average of the number of CaseNumbers of each Subject in a month but need to include months where there are zero CaseNumbers of a particular Subject. The solution offered nearly does it but doesn't count the months where there are zero case numbers. Presumably i need a measure to count the number of months first and then use that figure with the total count of CaseNumbers of each Subject. CaseNumber Subject CreatedDate 00001020 Council Tax Empty Property Discount Request 12/09/2016 00001021 Area Maintenance Request - Road Sweeping 28/09/2016 00001022 Area Maintenance Request - Fly-tipping 12/09/2016 00001023 Area Maintenance Request - Fly-tipping 12/09/2016 00001024 Area Maintenance Request - Fly-tipping 12/09/2016 00001025 Council Tax Enquiry 12/09/2016 00001026 Council Tax Single Person Discount Request 12/09/2016 00001027 Council Tax Bereaved Single Person Discount Request 12/09/2016 00001028 Council Tax Change of Address Request 01/10/2016 00001029 Council Tax Change of Address Request 12/09/2016 00001030 Council Tax Enquiry 05/10/2016 00001031 Council Tax Change of Address Request 05/10/2016 00001032 Council Tax Enquiry 12/09/2016 00001033 Council Tax Enquiry 05/10/2016 00001034 Council Tax Enquiry 12/09/2016 00001035 Council Tax Enquiry 12/09/2016 00001036 Council Tax Single Person Discount Request 12/09/2016 00001037 Council Tax Enquiry 13/09/2016 00001038 Council Tax Enquiry 11/01/2017 00001039 Area Maintenance Request - Fly-tipping 11/01/2017 00001040 Council Tax Enquiry 11/01/2017 00001041 Council Tax Change of Address Request 11/01/2017 00001042 Council Tax Enquiry 11/01/2017 00001044 Council Tax Change of Address Request 11/01/2017 00001045 Area Maintenance Request - Fly-tipping 13/09/2016 00001046 Area Maintenance Request - Fly-tipping 13/09/2016 00001047 Council Tax Landlord Change of Tenant Request 13/09/2016 00001048 Council Tax Single Person Discount Request 13/09/2016 00001049 Council Tax Single Person Discount Request 13/09/2016 00001050 Council Tax Single Person Discount Request 01/12/2016 00001051 Area Maintenance Request - Fly-tipping 11/01/2017 00001052 Council Tax Landlord Change of Tenant Request 14/09/20165.8KViews0likes3CommentsAverage of a monthly count of non numeric values
Hi, Help please...I've spent half a day on what I'm sure is very simple! I am trying to calculate the mean of a monthly count of non numeric values.... I am trying to get an average count by month (CreatedDate) of the number of CaseNumbers in each Subject. Does that make sense?!Solved5.8KViews0likes7Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.