Filter only those changed line items

fpopa
edited August 2023 in Modeling

Hello,

I want to apply a filter to a module in order to import the new values re-writing the old ones. Let me explain a bit.

I have a module dimensioned by Projects (a,b,c)
This is my view of the grid in the first phase:

Project

Start Date

End Date

New Start Date

New End Date

A

15/8/2023

30/8/2015

B

C

Second Phase:

Project

Start Date

End Date

New Start Date

New End Date

A

15/8/2023

30/8/2015

22/8/2023

15/9/2023

B

C

1/9/2023

15/10/2023

Third Phase: In order to modify the old start date and old end date only for Project A and Project C I want obtain this view before running the action.

Project

New Start Date

New End Date

A

22/8/2023

15/9/2023

C

1/9/2023

15/10/2023

There is a way to apply a filter in order to have the view from the Third Phase?

Cheers,

Adi

Best Answers

  • pyrypeura
    Answer ✓

    Hi,

    You can set your formula to be something like (ISNOTBLANK(New Start Date) AND New Start Date <> Start Date) OR (ISNOTBLANK(New End Date) AND New End Date<>End Date). This will give you a boolean that you can use to filter out the view to contain only changed rows

  • Hi @fpopa,

    In your dashboard, you can add a table with the same source module but which only displays the 2 line items ("New Start Dat" and "New End Date").

    In order to show only Project A & C, you can created a boolean line item with the formula "ISNOTBLANK(New Start Date") OR ISNOTBLANK (New End Date)" and use this line item as a filter in your table.

    Hope this helps!

    Benjamin

Answers