Hi Team, While Iam working on a Incorta report i got a calculated column like(Calculate Monthly Billing prior 6 months) using monthly billing amount. i know about calculating last 6 months and average and Variance. But dont have idea about prior 6 m...
Hi My Source table is Big Query Table and Target table is Big Query Table.I have created MV and sent to Data Destination getting below error.Big Query Table DateTime Format is as below. I have written formula forEXT_LAST_UPDATE DATE as COALESCE( to...
We are using a PySpark script inside Incorta to call an API and load data into a Materialized View (full load). Since loading this MV directly into a table is not feasible, we store the data in a history Materialized View (incremental mode) to mainta...
I'm having difficulty finding the documentation on the viable SQL Database Functions. I'm looking to see if it's possible to use any kind of TRIM() function during table definition, and can't seem to find the right page. Please see the attached scree...
Is this expression supposed to work? SO that the count of such "matches" can be aggregated in an insight to report on:case( (addMonths( $currentDate, 18 ) > WPR_test.Lease.Expire_Date), 1, 0)
