Difficult Aggr with COUNT

[Kakurin_Denis]

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]

Hi @Kakurin_Denis ,

Which are your actual bar chart dimension and measure?

[Kakurin_Denis]

I have 2 dimensions: RULESET and FRAUD_RISK_ZONE.

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

[agigliotti]

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

[mato32188]

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)

BR

m