Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have table with
dim -countries
and
measure - amout of flights
now i need to present everyday only top 36 countries and the rest on "Others" of that day(send nprinting)
now if i have day with 36+ countries its works fine
but if i have day with less for exmaple 33 coutries i get table with all those 33 countries and others with 0 value
i tired to turn off "include null values" on the dim and on add-ons turn off "include zero values" and didnt worked
i also tried to go to the measure and to do if measure=0 , null, else that measure.. and didnt worked
now i saw in this forum that someone wrote need to do aggr(if(sum(measure)=0,null(),dim),dim)
that worked.. but now if i do top 34 and not 36 its put me the last 2 coutries in the others even if i have today 35 coutries(should put only 1 country in others)
hope someone can help me with that 🙂
Thanks!
@Ran I think it's working correctly from how you describe the issue. Note that when you ask for "top N", there can only be N dimension values which also includes the dimension "Others"
that worked.. but now if i do top 34 and not 36 its put me the last 2 coutries in the others even if i have today 35 coutries(should put only 1 country in others)
When you ask for "top 34", there can be only 34 dimension values (including others). So when you have 35 countries, because you asked for "top 34", 33 dimension values will be countries. The remaining 2 will go to "Others"
@Ran I think it's working correctly from how you describe the issue. Note that when you ask for "top N", there can only be N dimension values which also includes the dimension "Others"
that worked.. but now if i do top 34 and not 36 its put me the last 2 coutries in the others even if i have today 35 coutries(should put only 1 country in others)
When you ask for "top 34", there can be only 34 dimension values (including others). So when you have 35 countries, because you asked for "top 34", 33 dimension values will be countries. The remaining 2 will go to "Others"
ok i thought when i ask for 34 it will give me 34 and the rest on others and not 33 +others
Thanks