-
Cards aren't loading
Cards are loading on the dashboard builder but not on the Embed Dashboard
-
Creating a Beast Mode to calculate field sums for remainder of year
Hi - I am trying to write a beast mode calculation that sums a field from an as of date until the end of the year. The variable is indexed across the year and want to count how many are left depending on what date is entered. For instance if 1/22/24 was the date it would count all the values indexed for the variable until…
-
Broken line chart and want to connect the dots
Hi - I have this beast mode that I am using in a bar line chart. However since there aren't values for each time interval the line is showing as dots. How do I get the line to connect? Here is the beast mode and I can't seem to get things connected without breaking syntax: CASE WHEN 'id'='LIABILITY' THEN SUM('value') END
-
Chart issue with line bar chart: line is showing up as dots
Hi - I am trying display a line bar chart combo but the line is displaying as dots and I want it to show up as a line. The dates for the line are at a lower frequency / longer duration (yearly) than the bar (monthly). Thanks for all the assistance.
-
Beast Mode: Syntax issues on filtering out a Sum Total
Hi - I am trying to remove certain IDs from a column then sum their values but can't get the syntax correct. Here is what I've gotten to but doesn't work. I can't add a filter on the card since the removed values need to be in another part on the chart. CASE SUM('values') - SUM(WHEN id='LIABILITY' THEN 'values') END
-
Beast mode to filter out certain ID field then sum the remaining IDs 'value'
Hi - I am trying to remove certain IDs from a column then sum their values but can't get the syntax correct. Here is what I've gotten to but doesn't work. Problem with adding a filter is the removed values need to be in another line on the chart. Case When sum('value') - (when ID='Liability' Then sum('value')) End or Case…
-
Beast Mode: How to aggregate a value for 1yr and remainder of the yr from a date?
Hi - I am trying to figure out how to aggregate values from a run date thru the end of the year as well as aggregating from that same date as_of_date for 1 year out. Essentially if the date is 5/31/23 it'll aggregate a value from that date through the end of the year (12/31/YY). Separately, from that same as of date…
