Trying to write a Beast Mode that calculates yesterday's date. DATE_SUB(CURRENT_DATE(), interval 1 Days) This formula validates just fine, but an error occurs when I try to use it in a table or see it in a drill down. Any ideas?
Grouped bar - Category as text and each bar (series) is a year
I need help making a grouped bar chart that shows each category as a text field (e.g. Aerospace, Automotive...) and each bar to be the value for the year. For example one group would show Aerospace revenue for 2018, 2019, 2020 the next group would show Automotive revenue for 2018, 2019, 2020. I am not having any luck…
Beast mode: find most recent date for distinct ID and compare
I am trying to create the "Type" column for data in the format below. The logic: Find the row with the most recent "Date" for a distinct "ID" (second column) and compare it to the "Became Date". If "Became date" is NULL or newer than "Date": "Type" column is set to Prospect. If "Became Date" is older than "Date": "Type"…
Help with LEFT function in Beast Mode CASE Statement
I am having trouble with the LEFT function in a CASE statement. It works as expected outside the CASE statement. When I use this beast mode: LEFT(`Material`, 4) I get the first 4 characters in the Material column. When I use this Beast mode (CASE when `Process`= 'Lathe' then 'Lathe' /*LEFT(`Material`, 4)*/ end) I get…