The total stations below are static numbers which can not be grouped by months. I have added the total stations in the dimension bucket and use the function distinctCountOver({master station}, [{super region},region], PRE_AGG), but it only shows on the region level. When I collapse the region and the stations don’t show on the super region level. Can the number show dynamically?
Hi @Li_Yang
When you take away the partition by region can you see it when you group?
Hi Max, if i remove region from distinctCountOver({master station}, [{super region},region], PRE_AGG), It will show the total stations on Super Region level, but I want it shows on every level - Super Region, Sub super region and Region. Total station count is a part of compliance calculation and users need to see it on every level. Or do you know another function I can use to show total stations count dynamically which can be used on the compliance calculation, but it is not impacted by date period?
Hi @Li_Yang
Why can’t you do just distinct_count?
1 Like