Dashboards & Analytics Discussions

Standard Deviation

Hi,=IFERROR(STDEV.P(BQ14348:CB14348)/AVERAGE(BQ14348:CB14348),0)Could please let me know how to convert above "STDEV.P" excel function in Incorta.

Condition when sending schema notifications (sFTP)

Hi,We send csv/excel sheets to a sFTP server for different use cases. Is there a way not to send an "empty" excel/csv file, the same way we have with data condition in data notifications? Or is there a way to send sFTP data via Data Notifications?Onp...

Dynamic Division in a row on Dahsboard

Hi, I'm looking for a solution on dynamic row division to be performed in top of dashboard in insight. The divided number should change according to filter selected. I have attached the file for reference. I want to add a row in the aggregated table ...

Comparing values between 2 columns from 2 different tables

Hi All,I'm trying to compare 2 columns which are having 2 different data source. In excel we can use this formula to get the result =VLOOKUP(C2,'[1.xlsx]1_Company 1'!$C$2:$C$106057,1,0). How can we achieve the same in Incorta ??Example : Table_1 colu...

Resolved! VLOOKUP In Incorta ?

How do I fetch the common values (Cluster ID) between these tables (See Snip)? Basically I want to have one more table and show the values (Cluster ID) that are common from both the tables. As you can see Cluster ID - 1063 is present in both the tabl...