11 Replies Latest reply on Jan 11, 2018 8:59 AM by Norbert Maijoor

    Assign Index numbers to rank performance

    shwetha sarma

      Hello,

       

      I would like help with a dashboard I'm working on. I am ranking the manufacturers based on their sales.

       

      For this, I want to put them into buckets and rank the buckets. I tried doing this with Bins and then creating a index parameter.

       

      The calculated field I tried was:

       

      If Bin = '85k' then index parameter = 1

      else bin = '100k' then index parameter = 2

      so on and so forth.

       

      This doesn't want. Please help me with the calc. This index calc with be used for other visualizations so I do not want to use rank function.

       

      Attached is sample workbook.