Logic for Calculating LFYTD (Last Fiscal Year to Date)
Hi Team, can anyone help me with the formula for calculating growth of previous FYTD. Fiscal year starts on April 1st and ends on Aug 31st.
Forum Posts
Filter multiple business schemas by clicking on a value
Hello, I'm trying to apply a filter to multiple insights (with different business schemas) by clicking on a value in one of the insights. Is this possible?I've used presentation variables in the past, but I don't want to type/paste a value in to set...
Seeking Dashboard Aggregate Formula to only show Grouping Dimension with multiple TransNo
Thank you for taking the time to look at this - I appreciate your help.My goal is to reduce an Aggregate Table dashboard to only show records for the primary Grouping Dimension that result in multiple transaction numbers. My Primary Grouping Dimensi...
Resolved! Filter by Date on three different date column
Hey There!I have filtering requirement, to apply the filter on three date columns, such as received, Approved and Rejected date:example: When user select between particular date, filter should apply on three date column as stated above, if either of ...
Using "In Query" Operator within Insight Filters
Hi Community,I was trying to use the "In Query" operator for applying a filter based on the result set returned from Query within Insight Individual filters. But for some reason, the insight does not pull any records when the filter is enabled. And I...
