GROUPLAST

2 followers
0
Avatar

FYI, Re:    https://www.datameer.com/documentation/display/DAS60/GROUPLAST

It says at the bottom:

Using GROUPLAST(#RawData!Item;#RawData!Order), you can return the last item ordered by each customer.

 

However, the RawData table does not have an "Order" column.

Amin Torabi

Official comment

  • Avatar
    Joel Stewart

    Amin, thanks for pointing out this inconsistency. Based on reviewing the data, I believe this is the actual function that was used in the example: GROUPLAST(#RawData!Item;#RawData!Item). 

    In this case, the value to display and the value to sort from are the same and are the "Item" column. 

    We'll work with our documentation team to get this corrected in the public documentation as well. 

    0

4 comments

  • Avatar
    Joel Stewart

    The example from the Datameer 5 version does make sense as it is. It's unlikely that this change was intentional since it's represented from a screenshot only. In this example, there are two separate columns we're using. Specifically, we're ordering by the "Order" column and then passing through the "Item" column as the result.

    In the Datameer 6 example, the version that I shared is valid as well: GROUPLAST(#RawData!Item;#RawData!Item) This simply indicates that we're using the same value to include in our grouplast output that we're using to sort. Specifically, we're ordering by the "Item" column (alphabetically) and then passing through the "Item" column directly as the result.

    Both of these use cases are valid for GROUPLAST itself. Regardless, we'll be sure to provide an update to the documentation such that the screenshots are consistent with the text on a given page.

    0
Please sign in to leave a comment.