Skip to Content
0

How to filter the values based on comparison with other columns(Dimensions)

Feb 28 at 05:43 PM

57

avatar image
Former Member

Hi Experts,

I am facing issue in webi, PFB below issue.

I have a 3 columns Data, time, status as below.

DATA TIME STATUS

PO 2/13/2018 Delayed

PO 2/26/2018 Ontime

PO 2/27/2018 Ontime

Below are the conditions for the requirement:

If we have status as Delayed only for a single Data column(Ex:PO) then in the report we need show only Delayed with latest date.

If we have status as Ontime only for a single Data column(Ex:PO) then in the report we need show only Ontime with latest date.

If we have status both Delayed,Ontime for a single Data column(Ex:PO) then in the report we need show only Delayed with latest date and need to exclude ontime from the table (Need to show only one record).

Please throw some light it would really helpful to me.

Regards,

Mahesh

capture.png (6.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ivan Yin
Mar 02 at 02:46 AM
0

This is not a very smart workaround for your requirement. Just try to add a new column to mask the rows that need to show.

  1. Create a variable using the formula as below:.
  2. Then filter this variable with 1 and the row you expect will show

=If Count([Status]) In ([Data]) = 2 And [Status] = "Delayed" And [Time]=Max([Time]) Where([Status] = "Delayed") Then 1 ElseIf Count([Status]) In ([Data]) = 1 And [Time]=Max([Time]) In Report Then 1 Else 0

Share
10 |10000 characters needed characters left characters exceeded