Questions & Answers

Have a question? Ask it here. Or reply and share your knowledge.

TOPICS MEMBERS

Join this category to participate in conversations and receive notifications when new posts are added.

JOIN

Join

0
Email Notifications for Jobs
Is there a way to get email notifications with the status of a Job upon completion? (Completed, Finished with errors, Failed, etc.)
- Tom FogartyIncorta User
- Inmar
- Tom_Fogarty
- 4 hrs ago
- 1 reply
- 3
- Dustin BasilEmployee4 hrs ago
- Questions & Answers
0
Logs Not getting Generated
Team, I observe in one of our production servers where Loader service is running, System Logs are not getting generated. May I know the reasons why a log would not get generated and also where do we…
- SrinivasPartner
- Wipro Technologies
- Srinivas
- 18 hrs ago
- 1 reply
- 5
- Dustin BasilEmployee5 hrs ago
- Questions & Answers
1
Python and PySpark libraries
In the materialized view, I'm attempting to import the python and pyspark libraries. But I get the error as in the image[native library can not be loaded ]. I have to use pyspark to conduct ML.…
- ManikandanPartner
- Cittabase
- Manikandan
- 5 days ago
- 2 replies
- 25
- 1
- ManikandanPartner4 days ago
- Questions & Answers
- Answered
- Answered
0
IO Error in Report
Team, We had recently upgraded our Dev server from 3.1.8 to 4.3.6 successfully. As part of Upgrade, We used the MigrationSnapshot tool to migrate the data from snapshots.…
- SrinivasPartner
- Wipro Technologies
- Srinivas
- 6 days ago
- 5 replies
- 25
- SrinivasPartner5 days ago
- Questions & Answers
- Answered
- Answered
0
SSO Login
We have set up Azure ADFS SSO Integration with incorta reports web login page. When we tried to login using sso, the page is taking us to Azure ADFS SSO and authenticating.…
- manoj mekaIncorta User
- Valet Living
- manoj_meka
- 6 days ago
- 17
- Questions & Answers
0
Unable to get output from first version/last version filter
I want to get the sum of qty group by customername order by orderid Iam getting #error this is the formula Iam attaching
- Ramaraju Hema KavithaPartner
- Gspann
- Ramaraju_Hema_Kavitha
- 8 days ago
- 2 replies
- 10
- Ramaraju Hema KavithaPartner7 days ago
- Questions & Answers
0
Invalid Date in Dashboard when using custom Session variable in dashboard applied filter.
Hi , I have created a session variable to get the day before yesterday date. $DayBeforeYesterday After I test this I get the right value. And when I use $DayBeforeYesterday in applied filters of the…
- Nikitha NimbalkarIncorta User
- Valetliving
- Nikitha_Nimbalkar
- 8 days ago
- 2 replies
- 19
- Anurag MalikEmployee8 days ago
- Questions & Answers
0
What is the difference between bin and if?
if(condition using less than, "xxxx","yyyy") // also will work like bin please clarify this.
- Ramaraju Hema KavithaPartner
- Gspann
- Ramaraju_Hema_Kavitha
- 8 days ago
- 1 reply
- 6
- Dan BrockEmployee8 days ago
- Questions & Answers
1
Not able to use NULL in formulas/calculations
My formula need is something like count(if x=3, Id, null) I only want to count distinct Id's and otherwise it should be null..i.e I don't want to count.…
- Nikitha NimbalkarIncorta User
- Valetliving
- Nikitha_Nimbalkar
- 11 days ago
- 1 reply
- 10
- 1
- Amit KothariEmployee10 days ago
- Questions & Answers
1
How do I clear the cache
The scenario was that, 1. I had source query for a table and the data was loaded. Call it Table1 and had a join with another Table2. 2. I needed to make source query changes to this table,…
- Nikitha NimbalkarIncorta User
- Valetliving
- Nikitha_Nimbalkar
- 11 days ago
- 8
- 1
- Questions & Answers
1
Unable to create a sample table on the go
I tried creating a table by using union all connecting to SQL Server data source. The query ran successfully on execution but was unable to add this as a table, it threw an error.…
- Nikitha NimbalkarIncorta User
- Valetliving
- Nikitha_Nimbalkar
- 11 days ago
- 6
- 1
- Questions & Answers
0
Unable to create material view
When I use any functions over the columns in select statement, then mv is not creating. eg: select name,id from schema.emp; // no issue with these select upper(name),substring(id,1,2) from schema.…
- Ramaraju Hema KavithaPartner
- Gspann
- Ramaraju_Hema_Kavitha
- 12 days ago
- 2 replies
- 15
- Ramaraju Hema KavithaPartner11 days ago
- Questions & Answers
- Answered
- Answered
0
How to download Insights?
- Ahmed EltanahyEmployee
- Incorta
- Ahmed_Eltanahy
- 1 yr ago
- 4 replies
- 158
- Dan RegisterIncorta User12 days ago
- Questions & Answers
- Answered
- Answered
0
Filtering on One to Many Relationships
Consider a schema with 3 tables: Animal (base table) - one row per animal (e.g. lion, bear, horse, trout, eagle...) AnimalColor - one row for each animal/color combo,…
- Dan NielsenIncorta User
- Inmar
- Dan_Nielsen
- 2 wk ago
- 6 replies
- 43
- Marc PaigeIncorta User12 days ago
- Questions & Answers
0
Changing ownership of a Folder/Dashboard
How do you change ownership of a folder or dashboard between existing/active employees? I have only found solutions on how to do this through deleting inactive employees.
- Mark SamuelsIncorta User
- Shutterfly
- Mark_Samuels
- 13 days ago
- 2 replies
- 8
- Mark SamuelsIncorta User12 days ago
- Questions & Answers
0
Onheap vs offheap memory
Team, I am new to Incorta. Can anyone help me understand how the onheap vs offheap memory works. Any references for documentation with examples is much appreciated.…
- SrinivasPartner
- Wipro Technologies
- Srinivas
- 1 mth ago
- 9 replies
- 65
- Dustin BasilEmployee2 wk ago
- Questions & Answers
0
Why would the row count for a query be off?
I have a SQL statement used for a table. The statement run in SMSS returns significantly more rows than the exact same statement in the table full load.…
- Marc PaigeIncorta User
- GC Services
- Marc_Paige
- 2 wk ago
- 3 replies
- 17
- Rasha MahranEmployee2 wk ago
- Questions & Answers
- Answered
- Answered
0
sorting by percentage
i have a table insight that summarizes the total sales by store formatted as percentage. i would like to sort the table by the total percentage descending. How do i do this ?
- amy yosteIncorta User
- Pickup
- amy_yoste
- 4 wk ago
- 4 replies
- 27
- Dustin BasilEmployee3 wk ago
- Questions & Answers
0
How do I find what's wrong in a "union"?
If I add a second query as part of a single table (a "union"), the tables will turn Red and I can't save my changes if something is different between the two.…
- Tom FogartyIncorta User
- Inmar
- Tom_Fogarty
- 3 wk ago
- 2 replies
- 22
- Tom FogartyIncorta User3 wk ago
- Questions & Answers
0
Issue while configuring kafka as a data source
Hi, I am trying to configure kafka as Data source.I am getting following bug: We are not able to create mapping file using the command which is given Incorta community. ( https://community.incorta.…
- sindhu rapoluPartner
- gspann technologies
- sindhu_rapolu
- 4 wk ago
- 2 replies
- 37
- Dustin BasilEmployee3 wk ago
- Questions & Answers
0
Can we use PARTITION BY functions in Incorta Sparksql?
- Amit KothariEmployee
- Incorta
- Amit_Kothari
- 3 wk ago
- 1 reply
- 22
- Amit KothariEmployee3 wk ago
- Questions & Answers
0
Color selection for visual not showing in dashboard, only in preview
Hi, When attempting to change colors of bars in a bar chart, the selections do not seem to be saving/changing. The color scheme I chose is showing in preview oddly enough. Please advise.…
- Peter ConwayIncorta User
- NJM
- Peter_Conway
- 1 mth ago
- 1 reply
- 20
- Peter ConwayIncorta User4 wk ago
- Questions & Answers
0
Conditional Formatting Based on Variable
Is it possible to conditionally format a value based on a date variable? For example if I have a table with dates represented in the column, can I highlight today's date using the $currentDate…
- Mark SamuelsIncorta User
- Shutterfly
- Mark_Samuels
- 4 wk ago
- 13
- Questions & Answers
0
Drill down back to original dashboard
Hi, When I drill down into a visual, I cannot find a way to drill back up to original dashboard. Is there a way around this? Thanks, Peter
- Peter ConwayIncorta User
- NJM
- Peter_Conway
- 1 mth ago
- 2 replies
- 27
- Dan NielsenIncorta User1 mth ago
- Questions & Answers
- Answered
- Answered
1
Table Insight
Question 1- All the content(headers and their values) in a table insight are highlighted when hovered over. Is it possible to disable the highlight for only the ones which I don't intend the user to…
- Madhu KiranIncorta User
- Inmar
- Madhu_Kiran
- 1 mth ago
- 4 replies
- 47
- 1
- Danish KhanEmployee1 mth ago
- Questions & Answers

1 2 3 4 5 11 Next

Have a question? Ask it here. Or reply and share your knowledge.

Members

View members

Have a critical support issue or bug? Submit ticket at our support portal:

Contact Support

Questions & Answers

Email Notifications for Jobs

Logs Not getting Generated

Python and PySpark libraries

IO Error in Report

SSO Login

Unable to get output from first version/last version filter

Invalid Date in Dashboard when using custom Session variable in dashboard applied filter.

What is the difference between bin and if?

Not able to use NULL in formulas/calculations

How do I clear the cache

Unable to create a sample table on the go

Unable to create material view

How to download Insights?

Filtering on One to Many Relationships

Changing ownership of a Folder/Dashboard

Onheap vs offheap memory

Why would the row count for a query be off?

sorting by percentage

How do I find what's wrong in a "union"?

Issue while configuring kafka as a data source

Can we use PARTITION BY functions in Incorta Sparksql?

Color selection for visual not showing in dashboard, only in preview

Conditional Formatting Based on Variable

Drill down back to original dashboard

Table Insight

Members

Categories

Tags

Home

Tags

Welcome!