How to add Different Expressions for Different rows of a table ???

[#1]

Hi All,

I have to design a table, in which each row will be filled up with different expressions using set analysis.

I am using LOAD * INLINE to create the table.

LOAD * INLINE [

    Services, Parameters, Value

    Alert Support, % Acknowledged, count({$<"Alert Support Ack SLA" = {'Met'}>}"Alert Support ID")/count("Alert Support ID")

    Alert Support, % Resolved ,count("Alert Support ID")  

];

The Expressions for Value field are different for different rows.

Is it possible to create this type of table, which will have different expressions for different rows.

Can someone please suggest what needs to be done ??

Please help ...

Thanks in advance

Regards

Sujeet

[#2]

Hi Jonathan / Antoine

Thank you very much for your time and help.

It is working fine now.

But when I am trying to show Services and Parameters field along with Flag and the calculated field, It is not showing properly. Can you please suggest, what can be done ?

Regards,

Sujeet

[#3]

Hi,

Some more information.

I tried this one. this is working but not fully.When I display the values Flag and Value (mExpr) in the straight table then it shows fine. But if I add other colums Services and Parameters then it is not working.It shows a common value for all the rows in the Value(mExpr) field.

I am attaching screen shot.

Also If I choose one of the values from the table then it is not showing the proper value.

Can you please suggest what can be done ?

[#4 · Accepted solution]

Hi,

For now it is resolved.

Inside pick() we should use Flag instead of RowNo().

Regards,

Sujeet