2 Replies Latest reply on Oct 31, 2016 1:45 AM by Liat Ferman

    Grouped-by calculated field\measure of measure ...

    Liat Ferman

      Hi,

      I'm trying to create a graph which is something like two-measures-histogram, I couldn’t think of a better name to describe it, but I'll explain:

      I have menus (identified by menu_id) and accounts (identified by account_id). Each account has a menu and each menu can have several accounts.

      I would like to know how many menus have how many accounts- for example, here is the data source:

      Menu id

      Account id

      1

      100

      1

      101

      1

      102

      2

      103

      2

      104

      3

      105

      3

      106

      4

      107

      5

      108

      6

      109

      7

      110

       

      Accounts per menu:

      Menu id

      CNTD(Account id)

      1

      3

      2

      2

      3

      2

      4

      1

      5

      1

      6

      1

      7

      1

       

      Now, I would like to know how many menus we have for each CNTD (account id):

      CNTD(Account id)

      CNTD(Menu id)

      Menu id's in count

      3

      1

      1

      2

      2

      2,3

      1

      4

      4,5,6,7

      And show it in a bar chart\scatter plot.

       

      Is there any way of doing that?

       

      Any help would be appreciated! Thanks