This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I need to create a new field 'Account Count', in order to count how many accounts I have. I have been attempting to use the field Account # to do a distinct count using the summarize tool. The problem is that many accounts have more than one date, business unit, and other fields that vary and are unique, all under the same account number.
Record 1 = Account: 1, Subscribe Date: 2018, Business Unit: A
Record 2 = Account: 1, Subscribe Date: 2018, Business Unit: B
Record 3 = Account: 1, Subscribe Date: 2019, Business Unit: A
In a situation like this, I am getting Distinct Count = 3, for that account number.
How can I get the distinct count of account #'s while ignoring all other fields other than the Account number??? I will need to add the "account count" field back into the original dataset in order to filter by business unit and such and get those counts.