GrantSmith Coach 
-
Re: Mandatory Single Select Filter
@Douglas_Digon They still haven't implemented this. The current workaround is to utilize a beast mode to display an error if not all the filters are selected (you can use a COUNT to check for du…2 -
Re: Governance datasets with Dataset source name
Hi @AnwarBham That level of detail doesn’t exist in the governance/metadata tables and isn’t easily available without getting very technical with some API calls1 -
Re: How to find the difference between 2 dates?
Hi @user048760 Another option would be to define a custom date offset dimension for the current date, last month and 2 months ago. You can then conditionally calculate the rolling average over the pa…1 -
Re: Can we do unpivot functionality in ETL, in the beast mode?
Hi @Salmas, This isn't possible with a beast mode as it's performed on a row by row basis and doesn't have the ability to add rows to your dataset. You'd need to do it with an ETL.2 -
Re: Is this doable? Seeing percent of total day sales by hour using Timestamp column.
Hi @DANIH Have you tried a window function with a case statement since you're attempting to only look at data from today? Last Year: SUM(SUM(CASE WHEN DATE(`Timestamp`) = CURRENT_DATE - INTERVAL…1
