Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, good day
I have a chart with three fields
Date : im date format
Time : in hour format
Plate: In text format
I also have a vperiodonummax variable , which calculates the last month.
I need to look for the máximum time and its associated plate with the group of plates of the last month.
May be like this:
Dimension
Date
Expression
Max({<Month = {"$(=vperiodonummax)"}>}Time)
FirstSortedValue({<Month = {"$(=vperiodonummax)"}>}Plate, -Time)
If that doesn't work, would you be able to provide a sample to look at?
May be like this:
Dimension
Date
Expression
Max({<Month = {"$(=vperiodonummax)"}>}Time)
FirstSortedValue({<Month = {"$(=vperiodonummax)"}>}Plate, -Time)
If that doesn't work, would you be able to provide a sample to look at?
Thanks works with FirstSortedValue !! However it appears a null value when two values are equal field time . How I can fix it ?
If you have only 3 dimentions you have to do some more simple for example
Load
Plate,
Max(Date)
From Nomber_Table
Group by Plate;
After you can Join This Table for example with your Fact Table with the column Plate
Best Regards!!!
Which one do you want to pick? May be try this
FirstSortedValue(DISTINCT {<Month = {"$(=vperiodonummax)"}>}Plate, -Time)