Using probabilities as measure and as a dimension

virilo_tejedor — Sat, 16 Nov 2024 19:00:54 GMT

I'd like to use probabilities as measure and as a dimension.

If we have a binary column gender, expressed a probability of being female, like the next one having four times 1.0, ten times 0.9 and one time 0.0:

is_female
---------
        1.0
        1.0
        1.0
        1.0
        0.9
        0.9
        0.9
        0.9
        0.9
        0.9
        0.9
        0.9
        0.9
        0.9
        0.0

I'd like to have a bar chart with the rounded sum.

In this case it should show: 13 women and 2 men.

I'm using the next measure, which behaves as expected:

=round(Sum(is_female))+round(Sum(1-is_female))

Which dimension could I use?

If I use 'is_female' as dimension, it thinks that 0.9 is another categorical value.

If I use round(is_female), it counts the 0.9 occurrences as ten women. Instead of 9 women + 1 man.

Thanks in advance

Cheers,

Re: Using probabilities as measure and as a dimension

virilo_tejedor — Mon, 02 Mar 2020 12:44:40 GMT

I solved it by detaching the info into two columns: gender and gender_prob.

So, one original row can be detached into two new rows, one for female and the other one for male.

gender_prob gender ----------- ------ 1.0 F 1.0 F 1.0 F 1.0 F 0.9 F 0.1 M 0.9 F 0.1 M 0.9 F 0.1 M 0.9 F 0.1 M 0.9 F 0.1 M 0.9 F 0.1 M 0.9 F 0.1 M 0.9 F 0.1 M 0.9 F 0.1 M 0.9 F 0.1 M 0.0 M

Now, I can use gender as dimension and sum(gender_prob) as measure

topic Re: Using probabilities as measure and as a dimension in App Development

Using probabilities as measure and as a dimension

Re: Using probabilities as measure and as a dimension