Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'd like to make a table with specific rows and count the value of interest for 1 dimension. For example, I want to choose 5 stores from my long list and count the number of products just for one type of category for these stores.
This table (countries and category) shouldnt change with other filters.
Can anyone suggest a way to do that please? Thanks in advance!
If its less than 5-10 countries , the easiest way would be use the if condition or match function.
For eg
If(Match(Countries,'A','B','C','D','E')>0, Countries).
It will give a dimension field with only these 5 countries. Can you try this and check if it works for your use case.
Also, Suppress nulls in the chart where you are using this field.
Hi @JJaky , for that, you need to know about set analysis and maybe alternates states.
Set Analysis allows you to change filters for your aggregation
Alternate States, can create another field to use to create another State of selections
Here a little example about set analysis, its going to count Number of products, considering filters, except Country and is going to show all available countries, and in Ctegory is going to filter with a text with your desired Category.
count(${<Country = , Category = {'TextOfCategoryWanted'} >} [number of products]
Hi @QFabian , thanks for your reply,
but I need to limit my table with just few lines from all available countries. I think I should look at the dimension limitations, but I dont have a clearer idea yet. Also, my list of countries shouldnt change because of other filters, only the values should (for days, weeks etc).
Hi @JJaky ,
If you apply the dimension limit for eg top 5 (lets say for countries) , the values will change based on the filters you select as it will now compute top 5 countries based on whatever measure you choose.
Is there an specific requirement for countries not changing ?
Can you not show all the countries ?
If you want to have the countries as same always , you can create a master dimension which is subset of your country dimension (To include only A , B , C ... countries ) and use this in your visual.
Hi @AnkitMadhukar , so how do you create a master dimension with subset of countries?
I have a column "Countries" with around 80 countries. TIA
If its less than 5-10 countries , the easiest way would be use the if condition or match function.
For eg
If(Match(Countries,'A','B','C','D','E')>0, Countries).
It will give a dimension field with only these 5 countries. Can you try this and check if it works for your use case.
Also, Suppress nulls in the chart where you are using this field.