topic Re: Set analysis on concatenated fact data in App Development

Set analysis on concatenated fact data

justalkak — Tue, 22 Apr 2025 14:55:29 GMT

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

Re: Set analysis on concatenated fact data

SRA — Tue, 22 Apr 2025 15:31:17 GMT

Hi,

Not sure to understand your requirement.

Is this what you are trying to do ?

Regards,

SRA

Re: Set analysis on concatenated fact data

justalkak — Wed, 23 Apr 2025 08:06:20 GMT

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..

Re: Set analysis on concatenated fact data

SRA — Wed, 23 Apr 2025 08:50:40 GMT

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

Re: Set analysis on concatenated fact data

lucasdemon7 — Mon, 28 Apr 2025 20:56:00 GMT

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.

Re: Set analysis on concatenated fact data

hanna_choi — Tue, 29 Apr 2025 00:54:53 GMT

Hello.

How about this?

Do you have to use the P function?

Thanks