Time

[smilingjohn]

HI

Please find the screen shots . let me try to explain it in a simple wasy

I have success date , appraoched date

My requirement are

it should show count of custome id  less than 50 mints   for the below formula

Success date - approached date lessa than 50 mints .

(i want to show count of those cusotmer id  who appraoched before 30 mints after subracting appraoched date from success date ).

I hope i am clear now

Thanks in advance

[tresesco]

Try to share a sample data set in qvw and explain your expected output against that. That would help us help you.

[smilingjohn]

hi tresesco

Just need to know the formula  to calculate the ytd  which are less than 30 mints

if u can give me a basic formula will be helpfull

[ramasaisaksoft]

Hi John,

SET TimestampFormat='DD/MMM/YYYY hh:mm:ss[.fff]';

TIMESTAMP([ Approval Due Date],'hh:mm:ss[.fff]') as [Approval Due Date_Time]

after that you can write the condition  as per your wish

[tresesco]

Something like:

Sum({<Date={'>=$(=YearStart(Max(Date)))<=$(=Date(Max(Date)))'}, MinuteField={'>30'}>}Data)

Note: Your minute field is assumed to be created in the script using minute().

[smilingjohn]

Hi Rama,

I hae the date fomate in the same way you suggested

date= 25-03-2016 19:22: 27

i have cutomer field

CutomerID= cidt=aa1 .... and so on

now i want to show the count of customer less than 30 mints ?

how do i take 30 mint from above date

[smilingjohn]

HI tresesco

I have date field like this

date= 25-03-2016 19:22: 27

and there is one more field like dateTime = 00:02:21

shall i consider date time as minute field to define less than 30 ?

[tresesco]

John Roy wrote:

hi tresesco

Just need to know the formula  to calculate the ytd  which are less than 30 mints

if u can give me a basic formula will be helpfull

So the basic formula did not much help. . That is why a sample was asked for to minimize the follow up questions. Check if you can share one.

[smilingjohn]

HI tresesco

Please find the screen shots . let me try to explain it in a simple wasy

I have success date , appraoched date

My requirement are

it should show count of custome id  less than 30 mints   for the below formula

Success date - approached date lessa than 30 mints .

(i want to show count of those cusotmer id  who appraoched before 30 mints after subracting appraoched date from success date ).

I hope i am clear now

Thanks in advance

[Digvijay_Singh]

This formats the time part into minutes -

=interval(round(frac(date('25-03-2016 19:22:27')),1/(24*60)),'mm')