Filter only those changed line items

fpopa · 2023-08-17T12:12:31+00:00

There was an error rendering this rich post.

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
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

Accepted answers

pyrypeura

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

BenjaminNiel

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

All comments

pyrypeura

BenjaminNiel

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

AlejandroGomez

You can create a line item subset with the line items and use it for filtering.

Quick Links

Can you help?

Unanswered questions

Dimensionality - Formula Help
I have a Price module where customers are ranked based on their unit prices. I also have a Comparison module, where I want to display the names and unit prices of top-ranked customers for comparison. The model includes a Customers list. In the Comparison module, I want to write formulas to bring in the customer names and…
Can there be a duplication in Process ID's
Can there be a duplication in Process ID's
Using Polaris and Classic
Client has spoke models built in Classic and now considering building Data Hub in Polaris in order to deal with sparsity. On the surface this seem possible but likely a bad idea. Has anyone done anything similar to this? Specifically, what did you have to do to ensure that data was compatible? Any thoughts or suggestions…