http://forums.visokio.com/discussions/tagged/dateadd/feed.rss Mon, 30 Oct 17 16:09:59 -0400 Tagged with dateadd - Visokio Forums en-CA http://forums.visokio.com/discussion/2923/subset-functions-calculating-sum-within-a-date-range Fri, 01 May 2015 11:26:48 -0400 DDrob 2923@/discussions
I haven't posted here before, I usually manage to work my issues out if I look at it for long enough but this one is just puzzling me. I feel like I'm doing everything right but I'm not getting the desired outcome.

My data is sales data, split by day and email address, where each row is a sale. I'm trying to create a new field which determines whether the sale was from a new customer (this was their first purchase in the last year), or an existing customer (purchased in the last year).

My steps were as follows:
1. Create a new field (StartDate) which is a DATEADD of -1 year to determine the lower end of my existing customer bracket.
2. Create a new field which is a function of SUBSET_SUM, SUBSET3 where Email=Email,Date>StartDate,Date
This will give me a sum of the sales where the email has appeared previously within my date range, and I can take 0 values as new and anything else as existing.

Now, my new field isn't returning anything and I can't work out why.

Hope you can help.

Thanks

P.S. I will attach the formula I used when I get access to my file again, although I'm pretty sure my syntax is correct.]]> http://forums.visokio.com/discussion/2764/formulae-identify-datetime-in-the-next-60-minutes Mon, 24 Nov 2014 04:15:48 -0500 nash 2764@/discussions
Date Result
15.05.2014 15:05:55 no
15.05.2014 17:10:55 yes
15.05.2014 17:20:55 no

I tried a similar logic as for moving average, but it didn’t work. I am not sure why. Maybe the date/time format works differently. ]]> http://forums.visokio.com/discussion/2758/formulae-datetime-format-for-cumulative-hours-beyond-24s Mon, 10 Nov 2014 15:49:12 -0500 aozols 2758@/discussions
The issue that I'm running into is when summing my "total session duration" date field. The HH:mm:ss format works up until the hour parameter hits 24 (as the setting for HH is a 24-hour clock). Is there a way to get around this 24-hour restriction? Should I be using a different format?

Example attached.

]]> http://forums.visokio.com/discussion/2603/formulae-adding-time-to-datess Wed, 18 Jun 2014 03:49:57 -0400 Valentina 2603@/discussions
I have a Date column and a column showing the number of days ahead. Eventually I would like to get the Date ahead i.e. if the Date today is 10/06/2014 then in two days it will be 12/06/2014. Please see the example below.

[Date]           [ DaystoAdd]       [Date ahead]
10/06/2014           2               12/06/2014
04/06/2014           5               09/06/2014
30/05/2014           6               05/06/2014

Any ideas how to achieve this?

Thanks in advance​]]>