Hi Team,
I am struggling with LAA aggregation and Filters.
Could you please some one assist me on below.
I have a calculated field which is named as “D-Selected for Audit”. Below is the formula which I have applied.
distinct_countIf({filenumber},{D -Current Queue}<>“yet to allocate” AND {D -Current Queue}<>" Not Selected for Audit" ).
For calculated fields not able to apply the pre_filter. Do we have any alternative option to get this fixed. Please assist. Thank you!
The issue isn’t with PRE_FILTER. I believe you can’t use distinct_countIf inside of sumOver. Can you try to change your distinct_countIf to distinctCountOver?
distinctCountOver(ifelse({insert conditions here}, {filenumber}, null), , PRE_FILTER)
Without seeing your data, I can’t tell what the correct partition is for your distinctCountOver, so you may have to adjust it. You may also have to change the PRE_FILTER to PRE_AGG.
1 Like
Hi @David_Wong , Thank you for your prompt response.
we have changed the distinct_countIf to distinctCountOver and while adding the calculated filed to the field wells we are getting the below error message. Could you please have a look in to the below and assist. Thank you!
Hi @tdr_Dinesh,
Can you try distinctCountOver(ifelse({insert conditions here}, {filenumber}, null), , PRE_FILTER) by itself without wrapping it in the sumOver? I’m not sure I understand why you were trying to do a distinct count inside a sum to begin with, so let’s just try the distinctCountOver for now and see if it gives you the correct result.