Skip to Content

Returning Min/Max values in a subset of data

I am tasked with trying to do this in Lumira. In Webi this is easily done.

I have a list of products orders by day. I need to know what is the most recent date ordered. I started by doing a date difference to today so there is a measure of number of days since last order. Now in webi, one would do a Min(daybtw;product) to return the min within the product dimension. How can this be done in Lumira? I know there is only a MIN aggregation on the measure with no notion of MIN within a subset of data.

ideas? possible?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 10, 2017 at 06:38 PM

    ok.. feel dumb. the aggregation works that way. I guess I was looking to GET the value as to use it. ie. what was order value for most recent order. ie. ordervalue where(daysbtw = min(daysbtw))

    ... ah Lumira..

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 10, 2017 at 06:38 PM

    ok.. feel dumb. the aggregation works that way. I guess I was looking to GET the value as to use it. ie. what was order value for most recent order. ie. ordervalue where(daysbtw = min(daysbtw))

    ... ah Lumira..

    Add comment
    10|10000 characters needed characters exceeded