
1. Re: Help with functions  Min Max LOD Fixed
Shinichiro Murakami Nov 30, 2016 11:38 PM (in response to Sebastian Cruz) 
2. Re: Help with functions  Min Max LOD Fixed
Bora Beran Nov 30, 2016 11:59 PM (in response to Sebastian Cruz)I need to get just 1 row per Student UID, and it has to contain the First Math Course taken and the Period related, also the Last Math Course and the Period and Final grade linked with this value.
[Period of First Math Course]
{fixed [Student Warehouse Entity Uid] : MIN(IF [Subject Desc]=='Mathematics' THEN [Academic Period] END)}
[Period of Last Math Course]
{fixed [Student Warehouse Entity Uid] : MAX(IF [Subject Desc]=='Mathematics' THEN [Academic Period] END)}
[Name of First Math Course]
IF [Period of First Math Course]==[Academic Period] AND [Subject Desc]=='Mathematics' THEN [Course Number] END
[Name of Last Math Course]
IF [Period of Last Math Course]==[Academic Period] AND [Subject Desc]=='Mathematics' THEN [Course Number] END
[Grade]
IF [Period of Last Math Course]==[Academic Period] AND [Subject Desc]=='Mathematics' THEN [Final Grade] END
You can drag all of them into a view and use them as dimensions with MAX aggregation. Since all but one value for a given student will be nonnull, MAX will pick that value. E.g. MAX(Grade), MAX([Name of Last Math Course]) and then drag [Period of First Math Course] onto filter shelf and exclude NULLs. This will remove students that never took a Math class.

3. Re: Help with functions  Min Max LOD Fixed
Sebastian Cruz Dec 1, 2016 4:37 PM (in response to Shinichiro Murakami)Thanks for your time and contribution Shinichiro! I did not know about "Add to context", it helped me a lot.
Regards!

4. Re: Help with functions  Min Max LOD Fixed
Sebastian Cruz Dec 1, 2016 4:39 PM (in response to Bora Beran)Thank you Bora!, this is exactly the output that I needed!
I really appreciate your support.
Regards!