topic Re: using min / max - filter pane expression in App Development

using min / max - filter pane expression

joeybird — Mon, 22 Feb 2016 14:36:54 GMT

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

please help

sunny_talwar — Mon, 22 Feb 2016 14:38:49 GMT

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

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

joeybird — Mon, 22 Feb 2016 14:53:32 GMT

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

please help

sunny_talwar — Mon, 22 Feb 2016 15:02:34 GMT

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

joeybird — Mon, 22 Feb 2016 15:08:27 GMT

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

please help