Visokio website     Downloads     Video tutorials     KnowledgeBase  
Bar/Line View: Sorting bucketed numeric data? - Visokio Forums
Bar/Line View: Sorting bucketed numeric data?
  •     earheart November 13, 2012 11:24AM
    When using buckets on an integer field, it turns the integer fields into text fields, which nullifies the natural sort order. If I plot based on the bucket field on a bar chart, 100 to 125 shows above 50 to 100. Is there a way around this?
  • 3 Comments
  •     paola November 13, 2012 11:33AM
    If you wish to change order in a category field you can go to
    Data> Manage fields >Options > Value order
    then drag little hand to change the order of appearance for different categories.
  •     earheart November 13, 2012 11:47AM
    That is much better than my hack...

    LEFT(
    IF([Hpc24]<100,BUCKET([Hpc24], 25),<br />IF([Hpc24]<300,BUCKET([Hpc24], 50)<br />,IF([Hpc24]<500,BUCKET([Hpc24], 100)<br />,IF([Hpc24]>=500,"500 ")))),
    SEARCH(" ",
    IF([Hpc24]<100,BUCKET([Hpc24], 25),<br />IF([Hpc24]<300,BUCKET([Hpc24], 50)<br />,IF([Hpc24]<500,BUCKET([Hpc24], 100)<br />,IF([Hpc24]>=500,"500 "))))
    ,1))

    This just returns the start of the range as an integer and sorts by that
  •     paola November 13, 2012 11:55AM
    It might be worth adding a formula field that will RANK the average value per interval (50-100; 100-125 etc), that you will be able to use for sorting.
Add a Comment

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership

Categories

Tagged