About Ruchita

Ruchita · 08-08-2023

Hello!I have a dataset with certain time of completion. They were originally ij long/big int format, and dusing formatDuration() in incorta, i have transformed it to (days, hours:minutes:seconds) format. This conversion of format results in an output...

Ruchita · 08-03-2023

Hi Community,I'm looking to connect to outlook email data for some analysis.Is there a custom connector in incorta to do so ? Or is it possible to connect to a power apps (dataverse table) ?Thanks in advance!

Ruchita · 08-01-2023

Hello !I have a few database tables that store a datetime value as a Long/Big Int Value. I was windering if there is a formula in incorta that i can use to retreive these values in the original datetime format.Kindly find an example below:Stored Valu...

Ruchita · 06-22-2023

Hello there, I'm looking to install a couple new libraries on incorta, so that they can be utilized in during creating a materialized view. Can someone guide me to a documentation for it or enlist the steps ?Thank you in advance !Regards,Ruchita

Ruchita · 06-05-2023

Hello,How can we make an incorta dashboard tab/view available as a link, so that whoever clicks on it, can download the tab as a pdf ?i need to access this link from an excel file (paste the links and once it is clicked upon, the pdf format of that d...

Ruchita · 08-02-2023

As far as i understand your example, you do have one column common in both Table_1 and Table_2. You can try to use the below formula as a work around instead of creating joins.If you do, then you can use a formula like below to compare:columnA_new: -...

Ruchita · 06-01-2023

Hi Prince,Thank you for your understanding of the case aptly. I used a nested max() because individual max() gives an error that it accepts only 2 parameters, something like this:max( abs(A-B), max( abs(B-C), abs(A-C...

Ruchita · 05-31-2023

Hi RADSr, Thank you for your response.The order need not be asending or descending in this case, because we're trying to determine if the values match in all three columns, if it does not, it needs to show by how much are the values different.

Ruchita · 05-31-2023

the calculation goes like this:row 1 : 10 - 10 - 10 (all the three are same) = 0row 3 : 10 - 0 - 0 (10 is the remaining value) = 10row 4: 10 - 9 (since two values are same i.e 10, it needs to take the difference from the value that is different)

Ruchita · 05-09-2023

Hi Shashidhar,Thank you for your prompt reply. I also found the below formula to work just fine.date( concat( string( year( addMonths( ...

User Statistics

User Activity

calculate average time from string type

connect to outlook data in incorta

Formula to convert Long datatype field to DateTime format without materialized views

How to install a new python library or module to use in incorta materialized view ?

Make a dashboard tab available as a downloadable pdf link

Re: Comparing values between 2 columns from 2 different tables

Re: Calculate difference between values from three columns

Re: Calculate difference between values from three columns

Re: Calculate difference between values from three columns

Re: Get start of the year based on the year of the previous month of a date