3 Replies Latest reply: Sep 19, 2012 5:53 PM by Mayil Vahanan Ramasamy RSS

    Bar Chart with Custom Ranges

      Hello All,

       

      I am struggling with creating the necessary calculated dimension / expression to create a bar chart with custom ranges.  Please see my data set below

       

      Trade IDAmount in EUR
      56465461€ 23,000.00
      564894€ 51,500.00
      5616516€ 100,000.00
      4894198494€ 123,000.00
      8165161€ 890.00
      984194€ 12,312,323.00
      5615618€ 590.00

       

      I am trying to create the bar chart showing the # of trades that fall into the following buckets while using an "if Statement":

       

      Amount in EUR - Buckets
      0 - 25,000
      25,000 - 50,000
      50,000 - 100,000
      100,000-200,000
      200,000 +

       

       

      Each Trade ID is unique.  Please help or my keyboard gets thrown across the room!