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


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
    Dec 31 '19 at 16:19
  • $\begingroup$ @Andewan09, can I send you my twbx och excel files? $\endgroup$
    – John Smith
    Jan 1 '20 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
    Jan 1 '20 at 11:12
  • 1
    $\begingroup$ @JohnSmith, sure send your files over $\endgroup$
    – Adewan09
    Jan 1 '20 at 14:13
  • $\begingroup$ Adewan09, where can I send the files? $\endgroup$
    – John Smith
    Jan 1 '20 at 14:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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