Dashboards & Analytics Discussions

Resolved! How do I default the max date of a table as a default value in a Date prompt in a dashboard?

The usecase here is how to calculate the max date from a table column and then default that to a date prompt in a dashboard.

Join two tables - only no matched rows

Hi Everyone,I would need help, I have both dataset below:1. Company item - contains all items assigned to company and branch2. Stock - contains stock value assigned to company, branch and items (there are only items having stock value > 0)What I need...

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...