Store value of Calculated Field as a Constant

Q&A
,
1

Hello,

I have a calculated field that calculates the median of my column Deposit Amount.
Median = median(Deposit_Amount)

I would like then to create a Check column that gives me for which Customer the Deposit Amount is above the median.

Check = ifelse(Deposit_Amount>Median,1,0)
Check = ifelse(Deposit_Amount>median(Deposit_Amount),1,0)

Both calculated fields for the Check don’t work because of aggregation problem.

Do you guys have an idea on how to proceed ?

Thanks :slight_smile:

2

Hello Jimny,

First of all Welcome to the Quick Sight Community.

Have you looked into this. -medianIf - Amazon QuickSight

Hope this helps.

Cheers,
Deep

3

Hello and thanks for the fast answer!

It doesn’t help me.

Let’s say in my dataset, the median of Deposit_Amount is 500.

If I do a calculated field:
Ifelse(Deposit_Amount>=500,1,0)

It will work. It will show 1 for the players who deposited over 500.

Now my median can change over time and may be different tomorrow when i refresh my dataset. I would like to use percentiles as well later.

I want to store the value of the calculated field Median(Deposit_Amount) so my Check:
Ifelse(Deposit_Amount>=median(Deposit_Amount,1,0)
Can work

Hope i’m clear.
Thanks a lot !

4

Hi @Jimmydean,
It’s been awhile since last communication on this thread, were you able to find a work around for your case or are you still in need of further assistance?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

5

Hi @Jimmydean,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!