This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hello Incorta fans,
Given a data set as below:
the data source is attached: Group_split_Test.csv
It has a column named value that contains a comma-separated data value grouped by a column namedKey , And it is required to split this single data int...
Hello again,
Given a data set as below:
the data source is attached: Group_Concat_Test.csv
It has a column named value that contains a single data per row, And it is required to concatenate these rows grouping by the key column and it should be sh...
In this Challenge, We need to get the cost and revenue for Customer Sales located in a specific country i.e in "Germany", It should be equivalent to the below SQL statement:
SELECT SALES.CUSTOMERS.CUSTOMER_NAME,
SALES.COST,
SALES.REVENUE
FROM SALE...
As a Sales Analyst, I need to have a chart to determine a revenue trend over years and months,
I am looking for something like this:
It is straightforward, Enjoy it
Hello Sirini,
To debug such an issue please follow these steps:
1-Create an insight showing the data as the expected results from the inquery filter syntax.
2-Create another insight for the main result set
3-Export both of the 2 insights to Excel f...
Hello RADSr,
Please check and confirm the below as per my understanding:
1-Assuming this is the main data set:
DateNo.Of vistors1-Jan22-Jan33-Jan54-Jan105-Jan126-Jan67-Jan48-Jan79-Jan810-Jan911-Jan112-Jan313-Jan014-Jan415-Jan216-Jan617-Jan818-Jan319-...
Hello RADSr, Please try the feature of creating Insights over the result set described here:https://docs.incorta.com/5.2/references-visualizations-insights-over-result-sets
Hi Srini,Please Try the following query using Incorta metadata DB:SELECT
A.NAME AS "Schema_Name",
B."NAME" AS "Job_Name",
B.DESCRIPTION AS "Description"
FROM
_IncortaMetadata.SCHEMA A
JOIN _IncortaMetadata.SCHEDULER_JOB B ON A.ID ...
.png "Employee"){kind=icon}
