Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all, Vegar
i have a region filed AMS,APJ,EMEA
and month 201601 201602 ,201603,201604,201605,201606,201607....201707
when i select region for AMS max month is 201707 to be selected (as data present for AMS 201707 is max data month)
when i select for EMEA max month is 201707 to be selected (as data present for AMS 201707 is max data month)
but when i select APJ max month is 201607 as we have data for APJ with max month is 201607 how i can i do this?
I think you need to specify max month for each region by creating Max field in load script and use that for filter (or in set analysis). Something like this:
Load
Max(Month) as MaxMonth,
Region
Resident Data
Group by Region;
I think you need to specify max month for each region by creating Max field in load script and use that for filter (or in set analysis). Something like this:
Load
Max(Month) as MaxMonth,
Region
Resident Data
Group by Region;
i have only one moth field we need to use in front end.
it should be selected default when user selected on perticular region