Data & Schema Discussions

Activity with in window of time

If I have a site and I want to bucket visitors in to 'Super Active,' 'Active,' 'Kinda Active,' and 'Meh' based on a rolling n-day window of activity ( e.g. 30 visits is 'Super' 2 is 'Meh' )That seems pretty straightforward for a given end date ( alth...

Incorta API Setup

I am trying to set up a python notebook (ipynb) to the Incorta API, however I keep running into a few errors.Following the python specific documentation here, I run into a "no such file in directory" error when I try to pip in the .whl file (screensh...

Resolved! Calculations in Schema

Two questions - 1. Round - according to documentation and per our testing round only works to the nearest whole integer. Anyone find a way to round to two decimals (like you can in Oracle SQL developer or excel?)Ex. 2.5621 in incorta will round to 3 ...

Formula column expression editor - what determines whether a table shows up?

I'm trying to build a formula column. Using the lookup() function, but I don't suspect that's meaningful to this question. - The schema has 45 tables in it. Only 9 of them show up in the expression editor's dialog box ( left side ) - Of the 45 ...

Unable to load SharePoint Online List data

I have setup OAuth connection with SharePoint Online and configured Datasource using it. While testing connection it shows Successful.But when I try to load data in Schema table, it only fetching metadata/columns but not the records.In Load status, N...