Count Unique in Group

Paula Rodriguez
Paula Rodriguez New Altair Community Member
edited September 2021 in Community Q&A

Is there a way to count unique values while grouping in Altair Monarch?

I'm working with a dataset that contains credit and debit cards information. I've done some analysis but now I would like to group the following way:

image

group by: BANK, TYPE, INDUSTRY

sum: AMOUNT, TRANS

count unique values: ID, PLASTIC

There is not a count unique option while grouping so I would appreciate and advice as to how to handle this operation in the future. 

image

 

 

Tagged:

Answers

  • Baba_Majekodunmi_703
    Baba_Majekodunmi_703
    Altair Employee
    edited September 2021

    Hi @Paula Rodriguez ,

    I think I know what this is challenging. The nature of your data table is such that All of the Records are unique based on all the categories; Bank, Industry, Type, even ID and Plastic.

    I used to work are a Debit Card Analyst for 7 years, and 4 of those years I also was a Credit Card Analyst. I understand what you're trying to accomplish, in theory, which is determine the number of active unique cards (or plastics) by the categories of Bank, Industry, and Type, but the data itself is preventing you from doing this because of it's structure.

    Is the ID field transaction IDs? And looking at some of the transactions, they look like duplicates.

    Bottom line is that, Monarch can do Credit and Debit Card analytics. I used it extensively working with such data over a 7 year period as a customer. I think that there's something about the data that is preventing us from creating the summary you're looking for.

Categories