Comments
-
Thank you, I cleared the cache and refreshed but still running into the issue. I use this process daily and nothing has been changed. Doesn't look like there are any options to refresh the federated data connector.
-
I realized I didn't replace the other current_date references with date. it worked this time thanks for the assistance!
-
I retyped the field names when I copied this over but I needed to change current_date to the date field I have since some of the data is in past years so it pulls correctly. but still got the same error where the chart wont load
-
@MarkSnodgrass thanks for the suggestion. Unfortunately when i make that update i get an error saying "An issue has occurred during processing. We are unable to complete the request at this time." @GrantSmith the current equation isn't aggregating and calculating the totals correctly with the snippet I first mentioned. Can…
-
That's unfortunately not possible
-
So I'm already using a beast mode: CASE WHEN id='Constant_Variable' THEN 0 ELSE SUM('value') END How would I combine that in without a syntax error?
-
Thank you! This cleared the syntax issue but realized it didn't get the value I'm comparing against and gave me negatives. How would I structure this in order to simply remove the ID='Liability' from the sum('value') so they aren't included?
-
How would I add one more day to the 1 year equation? I tried these without success '+ INTERVAL 1 YEAR + 1 Day' '+ INTERVAL 1 YEAR and 1 Day' '+ INTERVAL 1 YEAR 1 Day'
-
This is perfect, it worked! Thank you
-
Hi - Thanks for the help. To give more clarity the as_of_date is a column in the dataset for ~100 rows per day with every day being an option(daily occurrence). The example of 5/31/23 was just one instance of this. I'm trying to get the beast mode to calc the remainder of the current calendar year and a rolling one year…
