Data Designer - Default values to 0

@Wayne sorry for the inconvenience. I will redirect this to the product team for more visibility.

That’s great you found the workaround and shared here. Thanks.

I like this idea @Wayne. Basically during data preparation, if there is no data for some aggregation, you want to fill in 0’s instead of blanks. 

What all aggregations do you face this challenge in? Is when you Group By or Pivot?

I suspect in some it makes sense to add the above capability, in others, it might impact the performance of our processing a lot. 

It is for Group By only. Pivot already has this capability. Which was shocking to have it in one spot but not both.

I would have thought it would have been in the Group By more than Pivot.

Hi @Wayne 

Group By is a default database behavior and there are heavy performance cons if we want to change the way it works from only aggregating data to showing values with no data. Think around 30-100 times slower. Because of this we will not b going ahead with this.

Interesting, guess I’ll have to stick with my work around then. But, out of curiosity, aren’t you doing a group by in pivots?

Pivoting in Data Designer and Rules is kind of like a Case statement behind the scenes. 

Right, but you are doing a case statement to determine if a row meets a certain criteria and then if so performing a group by/aggregation on if it does or doesn’t.