Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
Some more information.
Hi,
For now it is resolved.
Inside pick() we should use Flag instead of RowNo().
Regards,
Sujeet