Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try to share a sample data set in qvw and explain your expected output against that. That would help us help you.
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
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
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().
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
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 ?
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.
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
This formats the time part into minutes -
=interval(round(frac(date('25-03-2016 19:22:27')),1/(24*60)),'mm')