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...
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...
Hi, I'm trying to set a Default value for the Dashboard Filter (in Prompt Filter) which is a date filter as " $lastmonthend" but this variable does not exists. I can see $lastmonthstart variable but not $lastmonthend. How can I create this variable a...
HiI am presenting data in Solid Gauge, if the value is more than 1000 Million, then value is showing. If the value is below 1000 million showing zero. Please let me know the issue
Hi,I am getting 3 values multiple times in a report, i want to calculate sum on distinct values, please let me know how to do.
.svg "Captain"){kind=icon}
