Skip to main content

Hi all,

 

I want to add a button where the user clicks and it filters the cases based on the following conditions. What's the best way of doing it?

 

FILTER PROCESS EQUALS 'IC SB Purchase Order Created';

FILTER PROCESS EQUALS 'IC SB Billing Created';

FILTER PROCESS EQUALS 'IC SB Invoice Receipt';

FILTER DAYS_BETWEEN(

    PU_LAST(

      "EKPO", 

      Round_Day("ACTIVITIES"."DATE1"), 

      "ACTIVITIES"."ACTIVITY_EN" = 'IC SB Billing Created'

    ), 

    PU_FIRST(

      "EKPO", 

      Round_Day("ACTIVITIES"."EVENTTIME"), 

      "ACTIVITIES"."ACTIVITY_EN" = 'IC SB Invoice Receipt'

    )

  ) > 30;

 

Thank you.

Guilherme Luz

Hi Guilherme,

 

Are you using view or analysis?

 

Thanks

Muthappan


Hi Guilherme,

 

Are you using view or analysis?

 

Thanks

Muthappan

Hi Muthappan,

 

I'm using analysis.

 

Tks,

Guilherme


Save these filters as bookmarks and there is an option for button on lick action to Load bookmarks.


Save these filters as bookmarks and there is an option for button on lick action to Load bookmarks.

Hi Muthappan,

I'm facing a similar issue, but I don't know how to add the bookmark with the required filters. Do you know how to do this? (the filters I require are not present in the dashboard)

Thanks, Ward


Reply