since ‎10-06-2022

User Statistics

  • 23 Posts
  • 1 Solutions
  • 13 Kudos given
  • 1 Kudos received

User Activity

Hi,I'm trying to achieve a rolling sum with a max condition. Basically trying to do a rolling sum but before we roll the 1st row sum to the next row we have to check with a condition if the rolling value is less than or equal to Zero. If it is less t...
Hi,I have start date (File Date) and end date in the table and i want to repeat the rows for each day from start date to end date. Is there any way that I can achieve this in MV? Please see screenshot - Appreciate your help in Advance. Thanks.
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 trying to calculate avg value for each quarter based on the current Month completed.I have the below table and I'm trying to calculate the Avg value for each Quarter.Avg Revenue for Quarter Q1 = (1+2+3)/3Avg Revenue for Quarter Q2 = (4+5+6)/3...
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...