Skip to Content
0

Returning Min/Max values in a subset of data

Oct 10, 2017 at 06:05 PM

17

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

James Batchelor Oct 10, 2017 at 06:38 PM
0

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..

Share
10 |10000 characters needed characters left characters exceeded
James Batchelor Oct 10, 2017 at 06:38 PM
0

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..

Share
10 |10000 characters needed characters left characters exceeded