Set analysis on concatenated fact data

[justalkak]

Hi,

I have fact data that needs to be concatenated and because of several reasons I cannot join the columns. So for the example below I would like to calculate with Set analysis the number of issues per Category, but it should calculate as follows:

for Category A : 2 (Issue X and Y) + 1 (Issue linked through Order M)

I believe it is possible with P function in Set analysis, but I cannot succeed with it.. appreciate any help

[SRA]

Hi, 

Not sure to understand your requirement. 

Is this what you are trying to do ?

Regards,

SRA

[justalkak]

No, I dont need count of Issues + Count of Orders. I need to have for Category A: 3 Issues ('X', 'Y' and 'a') - 'a' because it links through order M. If M would have link to two issues then it would be 4 in total..

[SRA]

Hi,

Can you give more information about your data model ? I imagine you don't have 1 table with the 3 fields as presented in you screenshot. Correct? How Issues, orders & categories are linked together?

Thanks

[lucasdemon7]

It is like you're on the right track with Set analysis! You can definitely use the P function to count distinct values, but it may require a bit of tweaking to handle the concatenation and linked issues properly. You might need to adjust your set expression to include the necessary conditions Board Results 2025 for both the issues and the linked order. Would you like help with that specific expression.

[hanna_choi]

Hello.

How about this?

Do you have to use the P function?

Thanks