Hi,I'm trying to write a query in MV (Spark SQL) which excludes the items ending with "_X" I understand underscore ("_") is single character wildcard in SQL and should be addressed as '%[_]x' or '%\_x' which will include the Underscore (_).  But it s...

Hi,I'm currently using this formula in dashboard filter - count(value1,groupBy(Value2,Value3)) and incorta is throwing an error. - " INC_04050708: Level based measures formulas are not supported in filters. Formula was: {0}"Is there any alternate way...

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