Is there a possibility to cluster coloring for certain statistical ranges?

This is what I have been able to achieve so far.

enter image description here


1 Answer 1


You can, as an example, create a binned field for the measure. The value range can be specified in the tooltip. I used a single color based continuous palette since (population) total is a continuous field.

[Edited] Based on your comment, I tested with a fixed dimension based binned field for the continuous measure. At least in my example file, the values make more sense now with the new binned field. I see China at 16M population, India at 14M and so on.

enter image description here

If this solution is relevant to your use case, you will need to be careful with dimensions included/excluded in the fixed calculation.

  • $\begingroup$ That's what I had initially. The thing is, I am ZN(SUM(..)), so NULLs are replaced with 0. Maybe N/A shall be used for those countries. Anyway. I want to cluster the colors based on SUM ranges. If that is possible. Thanks for you response. $\endgroup$
    – John Smith
    Commented Dec 31, 2019 at 16:19
  • $\begingroup$ @Andewan09, can I send you my twbx och excel files? $\endgroup$
    – John Smith
    Commented Jan 1, 2020 at 8:35
  • $\begingroup$ Adewan09, we have different statistical data, I am not able to produce what you produced. However, if possible, I can send all of my files over to you and let you tweak with them and send them back to me. Thanks a lot. $\endgroup$
    – John Smith
    Commented Jan 1, 2020 at 11:12
  • 1
    $\begingroup$ @JohnSmith, sure send your files over $\endgroup$
    – Adewan09
    Commented Jan 1, 2020 at 14:13
  • $\begingroup$ Adewan09, where can I send the files? $\endgroup$
    – John Smith
    Commented Jan 1, 2020 at 14:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.