4 Replies Latest reply: Feb 22, 2016 10:08 AM by Joanna Seldon

# using min / max - filter pane expression

Hiya

I have the following expression in a filter pane

If(((Frac([Order Date]))>=(21/24) OR (Frac([Order Date]))<=(8/24)), 'Night', 'Day')

I wish to add the min function

If(((Frac(min([Order Date])))>=(21/24) OR (Frac(min([Order Date])))<=(8/24)), 'Night', 'Day')

I cant seem to get this to work

• ###### Re: using min / max - filter pane expression

May be you need to add TOTAL if you are using this in a chart:

If(((Frac(min(TOTAL [Order Date])))>=(21/24) OR (Frac(min(TOTAL [Order Date])))<=(8/24)), 'Night', 'Day')

or

If(((Frac(min(TOTAL <FieldName>[Order Date])))>=(21/24) OR (Frac(min(TOTAL <FieldName>[Order Date])))<=(8/24)), 'Night', 'Day')

• ###### Re: using min / max - filter pane expression

Hiya

the top one seems to be working but, I have not have much luck with this as 'Day' seems to be greyed out

is there a way of converting the below expression to a filter pane?

if(Min(Order_Date)) < Shipment_Date ) or (Min(Order_Date)) > Shipment_Date )) , 'Night' , 'Day')

• ###### Re: using min / max - filter pane expression

You mean a list box? What dimension are you finding the min(Order_Date) on? Some sort of id?

• ###### Re: using min / max - filter pane expression

Hiya

There is a column called  order_date

and there is another order_check

it looks like

order_id   , Order_Check, Order_Date
1                       1               01/01/2015  19:36

1                       2               02/01/2015   09:00

1                       3               02/01/2015   09:10

1                       4               02/01/2015   09:45

is the order_check 1, I am trying to flag up, as drop down filter pane