Date Range and time range is not working

[#1]

Hi

I have scenario.

Need to select date range and time range using filters.For that i have created two calendar object with variables.

In addition to this i need to add time filters also like the attached image.

Requirement is count of orders based on selections like date range i.e. satrtdate and enddate

and time range i.e. 8am to 10 am like that.

Please do the needful

Regards

Thiru

[sunny_talwar]

May be try this:

Count({<YearMonth={">=$(=Date(Vstartdate, 'YYYY/MM/DD h:mm:ss TT'))<=$(=Date(Venddate, 'YYYY/MM/DD h:mm:ss TT'))"}, Time = {"=Frac(Time) >= MakeTime(8) and Frac(Time) <= MakeTime(10)"}>} Country)

[#3]

Hi Sunny,

In addition to the above how to add time  filters?

If i take time column as multi box it is showing all the values (but i guess only distinct values should be shown).Please see my calendar code and do the needful.

TIme filters like below

Starttime                     endtime

00:00 AM                    00:00AM\

24:00 PM                     24:00 PM

Please do the needful.

Regards

Thiru

[sunny_talwar]

Not sure I understand your question

[#5]

Hi Sunny,

In my application i have added filters for startdate and enddate using variables .this is fine using this end user will select date range and analyze.

same way i need to add two filters for time which will having time period like

starttime and endtime(as shown in the attached).

This part i am not clear how to add time filters like 00:00 am,01:00 am ,02:00 am  .....11:45 pm  like that.

case1:

if end user select date range like 2010-01-01  to 2014-01-01  then it will be all the orders between these dates

case2:

end user selects date range like 2010-01-01  to 2014-01-01 and time range 08:00am to 10:00 am then

it is everydate 08:00 am to 10:00 am how many orders happend?

Hope you got the point.

Regards

Thiru

[sunny_talwar]

So you are looking to get time as an input from user also? Can you send the updated app where you imagine user input and what format?

[#7]

Hi sunny,

Even i am also struggling to user input for time ,please check in attached image that is my requirement.

As mentioned above two cases required one is

1.Date range

2.time range

Ex:

1.Daterange:

2010-10-10   to 2014-10-10 

means all orders between this range

2.time range

if we select time like 8 pm to 10 pm

then

in the date range

2010-10-10   to 2014-10-10 

only between 8pm to 10 pm

Please do the needful

Regards

Thiru

[sunny_talwar]

May be like attached

[#9]

Hi sunny,

I have added inline data as starttime and endtime .

Can you please modify the set analysis syntax and let me know.

Thanks

Thiru

[#10]

Hi Sunny,

In addition to that please let me know

this

Sum({<Time={'>=(Starttime)<=(Endtime)'}>} country)

Thiru