Joel Stewart
- Total activity 778
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 4
- Subscriptions 347
Comments
Recent activity by Joel Stewart-
Official comment Hi Philip, thank you for the question. To be more precise with your matching in this example, I'd recommend using a function that supports Regular Expressions such as the COUNTMATCHES function. Th...
-
The supported syntax of each function is included in these documentation links: COUNTMATCHES and CONTAINS You'll notice that the COUNTMATCHES function accepts the data type of "<string with regex>"...
-
Official comment Hi Philip, the unique counts calculation in Flip Side is just an estimate as documented here: https://documentation.datameer.com/documentation/display/DAS50/Flip+Side#FlipSide-ReadingFlipSidecharts...
-
Is #date1 an empty string or is it null?
-
Since it completes with warnings, there is likely some details in the Job Trace that may point to the cause in more detail (i.e. with a stack trace). I'd recommend collecting and reviewing the Job ...
-
Official comment The web server is the process that retrieves the REST API responses. It must be running and listening for the REST API commands to succeed.
-
Official comment The payload differs slightly between different Datameer versions. I'd recommend creating an example object in the GUI once and then using the REST API to read the existing object's payload. This wi...
-
The number of GROUPBY functions used does increase with the number of columns that need to be deduplicated together. There is not another function that will automatically deduplicate records based ...
-
Yes, the SQL DISTINCT function is a good parallel to draw to the GROUPBY function.
-
John - The error reported indicates that there is no sheet named "CrashData2010" in that workbook. It appears that there is a sheet named "NYCNYPDCrashData2010" though. Please ensure that a valid...