topic Re: Difficult Aggr with COUNT in App Development

Difficult Aggr with COUNT

Kakurin_Denis — Sat, 16 Nov 2024 00:25:25 GMT

Good afternoon, dear colleagues!

I have a problem in my project. Hope someone could give me an advice.

1) I am loading table from db with columns:

INN; FRAUD_RISK_ZONE;SCORE_DATE;RULESET

2) I want to make bar chart, where dimension is MONTH(SCORE_DATE). But the case is I should select

only row with last score_date in month. On SQL it looks like

In measure I tried COUNT(Aggr(distinct MAX(SCORE_DATE, MONTH, INN_NUM))).

but it works bad...because it doesn’t select correct FRAUD_RISK_ZONE.

this is the result:

How I should write the measure that select rows with only max(SCORE_DATE)?
which takes only columns of this rows?
thank you!!!

agigliotti — Wed, 17 Mar 2021 08:43:34 GMT

Which are your actual bar chart dimension and measure?

Kakurin_Denis — Wed, 17 Mar 2021 09:02:16 GMT

I have 2 dimensions: RULESET and FRAUD_RISK_ZONE.

measure is COUNT(Aggr(distinct MAX(SCORE_DATE, MONTH, INN_NUM))).

agigliotti — Wed, 17 Mar 2021 09:46:13 GMT

could you post a sample app with mock data to take a look at?

mato32188 — Tue, 23 Mar 2021 20:13:39 GMT

Hi Denis,

what if you try to use set analysis script to tweak your expression?

count ( {< SCORE_DATE = {"$(=Aggr(distinct MAX(SCORE_DATE, MONTH, INN_NUM)))"} >} xxxx)