Alan
- Total activity 389
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 46
- Subscriptions 166
Comments
Recent activity by Alan-
Hi Jooha, Unfortunately there is not a way to retain the old schema automatically. However, you can create a custom schema file to use when you rescan. See the Custom Headers section of our Import...
-
Hi Craig, Please see our documentation: Working With Date and Time Information - Example of Date/Time constant within a filter
-
Amin, The issue here is that GROUPSUM is an aggregate function while GROUP_DIFF is a series function. We'll need to create a new sheet to get around the aggregate vs series function limitation per ...
-
Hi Amin, You can achieve this with the GROUP_DIFF function: Description Calculates the difference between the current value and the previous value seen in the group. The optional ["initial value"] ...
-
Hi Swethha, In addition to Joel's comments, I crafted this MySQL statement that will give you an explicit list for a particular user. Please note that the database schema is subject to change at a...
-
Steve, I see, I'm pretty sure you can get the desired behavior using the Exchange Data button to the right of the Add Data button. Otherwise you'll need to create a union sheet of the two sources...
-
Hi Steve, Have you tried using the Add Data button and then re-selecting your data link? This is how I would expect to be able to add additional data from other partitions even if you're using the...
-
Hi Thyagarajan, Source sheets are, by intended design, read only. The only way to get different data is to change it in the data source itself directly, then re-import. However, it would seem that...
-
Hi Amin, One way to achieve this would be to expose the EPOCH time with the TIMESTAMP function. This would allow you to operate directly on milliseconds with GROUPBYBIN. MSTODATE(GROUPBYBIN(TIME...
-
Hi Amin, GROUPBYBIN has difficulties dealing with some dates based on the underlying math. Our suggested method for binning dates is to convert a timestamp into a formated date that you can group o...