Mismatched Aggregation Error-Feature Request

Q&A
, , ,
1

I am unable to fetch the unaggregated value in ifelse statement in Quicksight. Please help me with this, its on urgent need.

2

Hi @graphs
would be great to get more information specialy the formula.
BR

3

ifelse(sumover(sum(value),[County,Broker])=maxover(sum(value),[County,Broker]),Broker,Null).So here basically I need to know the best broker in a county.But when I executed this query it shows “Custom aggregations can’t contain both aggregated and nonaggregated fields, in any combination”.Please help if there is a other way round to get this.Thanks.

4

Is there any Solution for this. I need this feature on Urgent Basis. Please Update.Thanks.

5

you try to get the broker? I guess that will not work that way. You have to solve the “then” part to an aggregated field like
ifelse(sumOver(sum(value),[County,Broker])=maxOver(sum(value),[County,Broker]),sum(value),NULL)

6

But that the part is like a non Aggregated attribute like the Name or something(Basically, String Element). So I can’t put Aggregation on it.Can you put this as a feature request on high-priority.

7

Hello @graphs !

I will mark this as a feature request for the Quicksight team.