Set analysis works if only one row is selected

[#1]

Set analysis works if only one row is selected

I’m trying to find minimum price for minimum date for each product.
I use straight table chart with productID as dimension and this expression

Min({$<Date= {'$(=min(Date))'} >}  Price)

 
But it ignores the chart dimension, and works well if only one row is selected.

Сообщение отредактировано: Uladzimir Kruhlik more data in application

[sundarakumar]

Use the same expression in calculated dimension..

It will b shown in all rows.

[#3]

unfortunately this expression doesn't work as dimension.

[Clever_Anjos · Accepted solution]

Check if fits your needs

[jerem1234]

See if this works for you:

FirstSortedValue(distinct aggr(min(PriseDay), ActionDate), ActionDate)

FirstSortedValue(distinct aggr(max(PriseDay), ActionDate), -ActionDate)

Please find attached.

Hope this helps!

[#6]

unfortunately this doesn't work on bigger amounts of data.

[#7]

I need to find the lowest price for the first day.

[Clever_Anjos]

This?

[jerem1234]

Hmm should work, try playing around with the formula. I don't know exactly what your data looks like so I can't be sure. For debugging, I'd start to see if aggr(min(PriseDay), ActionDate) returns all your min prices for each date by using maybe concat(aggr(min(PriseDay), ActionDate), '}'). Then firstsortedvalue should take the appropriate value when sorted by ActionDate.

If you could, post a sample with more data similar to your original app. Else try playing around with it.

Hope this helps!

[#10]

Thank You very much for your helpfulness and kindness.