6 Replies Latest reply: May 11, 2017 5:41 AM by Sunny Talwar RSS

    Aggregated dimension and measure - bar chart

    Jithu J

      I have data like this and I want to plot a bar chart where dimension will be count(mappedproducts) and measure is count(myproduct) and I want to filter the data based on flag. Is there any way to model this without aggregating outside the model. ex: I want to how many products has 10 mapped products,, how many products has 20 mapped products so on ..... how many zero mapped products are there like that.... Something like below chart

       

       

       

         

      my productmapped productflag
      10000281100945201
      10000281100945211
      10000281100945220
      10000281100997090
      10000281100997100
      10000281150001000
      10000281150743220
      10000281151063010
      10000281151063020
      10000281151063030
      10000281151063040
      10000281151063051
      10000281151063061
      10000281151063071
      10000281151063081
      10000281151063091
      10000281151063101
      10090507100905081
      100002811001935981
      100905079461154711
      100905079461223661
      100905079461706741
      100905079461757511
      100905079461896471
      100002812026315881
      100905071005672501
      100905072026302461
      100905072026302471
      100905072026302481
      100905072029604890
      100905072031989050
      100905072031989070
      100905072031989090
      100905072031989110
      100905082047317100
      100905082047541330
      100905082047541460
      100905082066683160
      100905082066683170
      100905082066683290
      100905082066683311
      100905083002309971
      100905083005103091
      100905083005103101
      100905083005103110
      100905083005103120
      100905083005103130
      100905083005103600
      100905083005680140