topic Show Max Date On Dimension Field in Visualization and Usability

Show Max Date On Dimension Field

griffin2571 — Tue, 13 Dec 2022 14:58:18 GMT

I have two records with the same Vin number but only want to show the most recent date. It's my understanding that you can't use set analysis like it's a measure. I used this expression but all it has done is change the other record to 9-30-22. How do i create an expression show the table will only show the most recent date.

=Date(Aggr(Max(TOTAL [Drop Off Date]),[Drop Off Date]),'YYYY-MM-DD')

Status	Car Vin	Job Description	Comments	Drop Off Date	Type of Repair	Repair Status
In Shop	82000917	Oil Change		2022-09-30	Drop off	NO DELAYS
In Shop	82000917	Oil Change		2022-06-01	Drop off	NO DELAYS

It should only show this record

Status	Car Vin	Job Description	Comments	Drop Off Date	Type of Repair	Repair Status
In Shop	82000917	Oil Change		2022-09-30	Drop off	NO DELAYS

Re: Show Max Date On Dimension Field

Rockstar7 — Tue, 13 Dec 2022 15:20:23 GMT

While doing aggr you need to add Carvin as well in the expression like this

Date(Aggr(Max(TOTAL [Drop Off Date]),[Car Vin],[Drop Off Date]),'YYYY-MM-DD')

or you can use a simpler one like below

Aggr(max([Drop Off Date]),[Car Vin])

Re: Show Max Date On Dimension Field

griffin2571 — Tue, 13 Dec 2022 15:27:05 GMT

I tried both your formula but it only changed the second record to 9-30-22. How do i get the dimension to only show that one record with 9-30-22.

Status	Car Vin	Job Description	Comments	Drop Off Date	Type of Repair
In Shop	82000917	Oil Change		2022-09-30	Drop off
In Shop	82000917	Oil Change		2022-09-30	Drop off

Re: Show Max Date On Dimension Field

Rockstar7 — Tue, 13 Dec 2022 15:34:37 GMT

tested the same in my environment it is working fine and giving only one record which contains 30-09-2022. Please verify again