topic Re: Max date availability in Visualization and Usability

Max date availability

saurav5246 — Fri, 15 Mar 2024 16:40:13 GMT

Hi All,

I have to find the max date(MMYYYY) in which filter value PCAAT00 and PJABF00 must available for bate c.

Here i attaching the data set for reference.

max mmyyyy is 022024.

max({<bate={'c'},filter={'PCAAT00','PJABF00'}>}MMYYYY) ---032024 which is wrong

Thanks.

Re: Max date availability

Clement15 — Fri, 15 Mar 2024 17:06:12 GMT

Hello, depending on how your model is trained this should work.

min(aggr({<bate={'c'},filter={"PCAAT00","PJABF00"}>}max(MMYYYY),filter))

Re: Max date availability

saurav5246 — Fri, 15 Mar 2024 17:13:22 GMT

Sure, Let me try.

Re: Max date availability

pravinboniface — Fri, 15 Mar 2024 17:31:38 GMT

@saurav5246 In your data, the row with value 102.38, MMYYYY indeed has a maximum 0f 032024.

If max is having an issue with the date format, I would use:

max({<bate={'c'},filter={'PCAAT00','PJABF00'}>}date(date#(MMYYYY,'MMYYYY'),'MMYYYY'))

But it looks like you are already getting the right value.

Re: Max date availability

saurav5246 — Fri, 15 Mar 2024 17:35:20 GMT

But i have to get max date in which both code(PCAAT00,PJABF00) must present. Date is 022024.

Re: Max date availability

pravinboniface — Fri, 15 Mar 2024 18:31:49 GMT

@Clement15 Interesting solution- how does this work?

Re: Max date availability

Clement15 — Tue, 19 Mar 2024 08:06:47 GMT

Thanks to the aggr you take the maximum date for each filter. Since we want the last date where all the filters took place, we take the smallest of the maximum dates because all the filters will have reached or exceeded it.