Expression Set Analysis

[andrea90casa]

Hi at all,

I have a dataset with one field called data and another one called unit price

I would like to create a formula that shows me the first available unit price for a specific product, i have created a variable called MinData with this formula =Min(data)

And then i wanted to try this one

Avg({<data = $(=MinData)>}Unit_Price)

But it doesn't work, anyone can help me with this..

Best regards

Andrea

[Anil_Babu_Samineni]

May be flower bracket missed as syntax of set expression

Avg({<data = {$(=MinData)}>}Unit_Price)

[andrea90casa]

Hi Anil

I tried with curly brakets in that position but it hasn't worked too

[krishnacbe]

Try below expression

Avg({<data = {"=$(=MinData)"}>}Unit_Price)

or

Avg({<data = {"=$(MinData)"}>}Unit_Price)

[Anil_Babu_Samineni]

Try this

Avg({<data = {'$(MinData)}>}Unit_Price)'

[andrea90casa]

with this solutions it calcs the average considering all the unite price and it doesn't give to me the only first one

[krishnacbe]

Can you share some sample data to debug.

[andrea90casa]

This one for example.

In the first text box i would like to see the first price, for example for the product A. So the correct value should be 1,1

Andrea

[krishnacbe]

Check below expression

=aggr(avg(Unit_Price),Product)

[andrea90casa]

With that expression the result is 1.188 so the mean of all that value, so it is not give to me the min data unit price (01/01/2017 = 1,1)