Create a new measure

[GaryChin]

Hi All,

There is three field:

measure_time; measure_point; measure_value;

And the measure_point contain 3 parameters Temp, CO2, HR

I want to create three new Measures to sort the value, call PointTemp, PointCO2 and PointHR

In the Edit expression, I tried to type 

{<measure_value ={"*"}, measure_point={"CO2"}>}

But displayed Error. How to write the expression?

Regards

Gary

[Arthur_Fong]

I don't get you with:

I want to create three new Measures to sort the value, call PointTemp, PointCO2 and PointHR

Can you provide your expected result?

[GaryChin]

The present data and Field

Expected result

Thanks!

[Arthur_Fong · Accepted solution]

Try this:

CO2:

SUM({<measure_point={'CO2'}>}measure_value).

Repeat other values as new expressions.