2 Replies Latest reply: Mar 9, 2016 10:02 AM by Prescilia Andaloro RSS

    Histogram with requirement for a field that depends on another field

    Prescilia Andaloro

      Hello,

       

      I would like to create multiple graphs.

       

      I have a field area (Lorraine, Alsace, Rhône-Alpes, etc...), a department field (Moselle, Meurthe-et-Moselle, Meuse, Vosges, Bas-Rhin, Haut-Rhin, Ain, Savoie, Loire, etc...) and finally a salesId.

       

      I would like to create a histogram that would give me for a selected region of the top 2 departments where there is more sales. For example, I want my histogram shows me for the Rhône-Alpes region, only the relevant departments by region and then keep only top 2.

       

      I would find another solution than using the current selections. I tried with a set analysis but I have not found the right syntax for now...

       

      Thank you in advance,

       

      Prees