Can I filter on aggregated data in use cases?

Hello, I am building a use case and I need to calculate several variables and show aggregared data in a form of 'SUM' vaue.

I do have a lot of data for the dimension I am using and I would like to limit those according to the 'SUM" value.

Is there any way that I could place aggegated filter?

E.g. SUM(A+B)>5

I am not able able to use the Pull-Up function here.

I would not prefer to Limit the rows or use First K Rows.

Ideally I am looking for an Option which would work in similar way as "Having" works in SQL.

Will be grateful for any answers/ hints.

Best regards,

Krzysztof

Page 1 / 1

You could set the individual sums i.e. A and B as KPI's in your saved formulas. As long as they are being saved as KPI's they can be re-used anywhere else, even as filters.

Your filter would be something like this

FILTER SUM( KPI("A") + KPI("B")) > 5

Hi, have you tried the PU with domain table ?

FILTER PU_SUM(DOMAIN_TABLE("casetable"".casekey"), case.value) > 5

You could set the individual sums i.e. A and B as KPI's in your saved formulas. As long as they are being saved as KPI's they can be re-used anywhere else, even as filters.

Your filter would be something like this

FILTER SUM( KPI("A") + KPI("B")) > 5

Hi Mondal, Filter statement should not contain Standard Aggregation, regardless of the input this statement throws an error.

Hi, have you tried the PU with domain table ?

FILTER PU_SUM(DOMAIN_TABLE("casetable"".casekey"), case.value) > 5

Above comments should work if you want to sum over the different events in a case.

If you want to filter based on event records instead of case aggregations a simple statement like:

FILTER (A + B > 5); should work

From your context, it is not entirely clear what the issue is

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN