Calculated field with max row Limit

[Kamani_Charles]

I have a table calculation returning the median of a column that surpasses the 5,000 row limit by enough that it may not be as accurate to rest on the idea that the 5,000 rows are a representative sample of the larger subset.

Reason I am doing this is to then hide all other fields and display a single digit visualization.

Is there anything I can do to show a more representative Median/Average value of the whole query; larger than the 5,000 row limit?