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

    Assign Index numbers to rank performance

    shwetha sarma



      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.