Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table with two fields like this:
Table1:
ID, Status
1, pass
2, fail
3, pass
1, fail
1, fail
2,pass
3,pass
- Now i will take straight table with ID.
- In the expression i want to write like this if the status is fail for any particular ID i want to display as fail under status.
i.e in the above data for id=1 there are 2 status(2 fails,1 pass) so i need to get fail under status.
For example i want to display in straight table like this:
ID Status
1 Fail
2 Fail
3 pass
how can i do this
Hi,
Create a Straight table.
Add dimension as ID
and Expression as
if(count({<Status = {"fail"}>}ID)>=count({<Status = {"pass"}>}ID),'Fail','Pass')
Regards,
Kaushik Solanki
Hi,
Create a Straight table.
Add dimension as ID
and Expression as
if(count({<Status = {"fail"}>}ID)>=count({<Status = {"pass"}>}ID),'Fail','Pass')
Regards,
Kaushik Solanki
Thanks kaushik..