Calculate the growth in unique objects by month
Hi, I've been looking around and have found lots of examples of calculating the number of unique values occuring per year or per month, for example for calculating the number of unique website visitors per month. But what I need to do it calculate the number of truly new unique values each month, so it's a calculation of growth not occurance. For example: MonthYear Company Name Feb-20 Company A Feb-20 Company B Mar-20 Company A Mar-20 Company C Would be displayed as: MonthYear Growth Feb-20 2 Mar-20 1 Any help?
Unique Values based on Different Filters
Hi All, I am struggling to find the out the unique values based on the different filters. Here below is my sample data table and I want to find out the Associate name based on the highest spend by Division By Subcategory. For below table the expected one answer would be like below. I want the same figures for from the data Expected Result: I want all details Associate Name Sub Category Division C1 Group Road A1 Labour Utilities A1 Waste Construction Data Table Sub Category Division Associate Name Total Spend Labour Utilities A1 8 Labour Utilities B1 15 Labour Utilities C1 12 Labour Utilities D2 9 Labour Utilities A1 45 Hardware Engineering C1 31 Hardware Engineering D2 39 Hardware Engineering A1 42 Waste Engineering C1 2 Waste Construction D2 13 Waste Construction A1 28 Waste Construction A4 15 Work Construction A5 43 Work Infrastructure A1 8 Work Infrastructure C1 48 Work Infrastructure D2 21 Group Infrastructure A1 37 Group Road A1 19 Group Road C1 45 Group Road D2 19 Note: I am using direct query as data from source system. Please help me.
