% of two custom columns

Question & Answer
1

Hi there, how can I get a % of the two columns here sum(column1)/SUM(columnB)?
The first is: distinct_countIf({account_name}, {country} <> ‘italy’)
The second is simply a distinct count of the value

Since these are not numbers I am not able to sum them up.

image

2

Can you try wrapping these in sumOvers?

sumOver(distinct_countIf({account_name}, {country} <> 'italy'),[])

Then do the same for your other calculation and divide the two.

3

That worked, thanks!!!

1 Like