Pablo Redondo
- Total activity 35
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 17
Comments
Recent activity by Pablo Redondo-
I recommend using the date functions, but you can also filter on the year column. Set year column equals year(today()). Select as input a "Formula" instead of a "constant" (See below).
-
HI Tim, I would use the ngram function. It takes in a list value (the result of your concat) and the n value (3). ngram(<your concat list>;3). Hope this helps. Pablo
-
oh.. I see. What you are looking at id the difference in miliseconds. In other words, substracting two timestamps or dates by default will produce the result in miliseconds. So to convert it to day...
-
Use the roundtime function to round your timestamp to date: ROUNDTIME(#timeEnglishFormat;"1d")
-
FYI: Some how my backward slashes get removed from my comments so make sure the formula bar there is two backward slashes ("\") before the ("|").
-
Each function will have good info on its functionality (e.g.: http://www.datameer.com/documentation/display/DAS50/REPLACEALL) and if you click on the "<regular expression>" link it will forward yo...
-
Hi I believe the best approach to calculate your sets is "sessionizing" your data using the GROUPBYGAP() function. The groupbygap takes a timestamp and the maximum time between each event that woul...