5 Replies Latest reply on Nov 30, 2016 11:26 PM by Shinichiro Murakami

    Side column chart

    gbemi.bruschi

      Hi, I am looking to create a side by side column chart to count the number of customers that fall within specified spend buckets (total amount
      they spent in a given year). I would like to use in columns the spend bucket and year (Last Year or This Year) for it to look like the attached image.

       

      The problem to create this view is that my data is structured withone line per Customer ID and very little granularity. I have a Customer ID, a
      last year spent, a this year spent, Last Year bucket, This year spend bucket. (see attached for a sample data file)

       

      Can anyone help me figure out how to make this work?

       

      Thanks a lot for the help!