Forum Discussion

icturion's avatar
icturion
Icon for Resolver II rankResolver II
4 years ago
Solved

Distinc count by record values

Hi, hope someone can help me with the following: Based on the table below, I want to calculate how often a certain combination occurs per unique MO_Monsternummer value? concerns the combinat...
Need Help
CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
4 years ago

A trickier solution to your tricky question,

  • icturion's avatar
    icturion
    Icon for Resolver II rankResolver II
    4 years ago

    thank you. I didn't realize the solution was so tricky

  • icturion's avatar
    icturion
    Icon for Resolver II rankResolver II
    4 years ago

    Hi CNENFRNL,

     

    Is it also possible to calculate the numbers per category in a separate measure? I also want to be able to calculate with the different results per category. For example by dividing the number of category "1 and 2" by the number of category "1 and 4". so 2/5 = 0.4