Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
You can use below expression.
Sum({<Department = {"=Rank(Sum(Sales))<=2"}>}Sales)
Regards,
Kaushik Solanki
Look at the attachment, this is the map of France. For example, (top right on the map - region in blue) the region nammed "Lorraine" include four departements which are "Moselle", "Meuse", "Meurthe-et-Moselle" and "Vosges".
How can I create a chart giving me the number of sales departments belonging to a region ? This makes 4 bars in my graph about a region. Tha'ts what I want to do. You need to know is that, these two fields "region" and "departement" are in the same table.