If you’re wanting to easily show where data is existing within colorful, equal quadrants that are spaced based on the underlying data - below is a straightforward way to build this out of the box with Omni’s powerful visualization tools!
Video walkthrough of exactly how to do this all within Omni’s point and click interface!
If statements utilized for easy plug and play:
# Upper Left
=IF(A1 < AVERAGE(A:A), MAX(B:B) * 1.2, 0)
# Upper Right
=IF(A1 >= AVERAGE(A:A), MAX(B:B) * 1.2, 0)
# Lower Left
=IF(A1 < AVERAGE(A:A), MAX(B:B) * 0.6, 0)
# Lower Right
=IF(A1 >= AVERAGE(A:A), MAX(B:B) * 0.6, 0)
