Skip to main content
Known Participant
Nov 28, 2023 7:09 AM UTC
Question

Aggregation in expression

Hi All,

I have used the aggregation function in expression rule to count the values based on certain column. But I need to filter that the calculated count value should not be greater than 8. Can anyone please help me out.

    2 replies

    prakhars0731
    Inspiring
    Nov 28, 2023 9:11 AM UTC

    Hi [mention:bb176b67c26c4e89b2173f39160c9f46:e9ed411860ed4f2ba0265705b8793d05] first you should filter out the values in column . if you are using record than you can use user filter or source filter for that than you can apply the aggregation fuction on the column. I hope this helps you.

    Known Participant
    Nov 28, 2023 10:15 AM UTC

    Hi prakhars0731, I am not using record type, but instead getting values from table through expression rule. Could you please tell me how can I apply filter on count column having alias name.