set a dimension with Max and min values

garry107 — Mon, 11 Jun 2018 18:56:13 GMT

Hello,

Have a question,

how to work this situation.

I have a table with the below fields:

Dimension1,

Date, MM/DD/YYYY HH:MM:SS

Landmark, 'A'-'Z'

Start Timestamp,MM/DD/YYYY HH:MM:SS

End Timestamp.MM/DD/YYYY HH:MM:SS

I have to distribute DImension 1 into Day and Night

if ( ( Date greater than min({<Landmark = 'D'>}Start Timestamp)

and

( Date less than max({<Landmark = 'Y'>} End Timestamp) ),

'Day','Night').

How can this be achieved.

Thanks,

Garry

Re: set a dimension with Max and min values

sunny_talwar — Tue, 12 Jun 2018 02:37:52 GMT

Is this something you are looking to do in the script or front end app? Also, are you able to share a small sample to show your data looks like?