GrantSmith Coach 
-
Re: Displaying Average of Data with Average of Each Part of the Series
You can use three different beast modes to handle this: Combined: AVG(`Handle Time`) Inbound 1: AVG(CASE WHEN `Call Type` = 'Inbound 1' THEN `Handle Time` END) Inbound 2: AVG(CASE WHEN `Cal…2 -
Re: Identify a duplicate
Ah, you can't use it within a formula tile. That's just the format for a beast mode. If you're looking to use Magic ETL take your data and feed it into a Group By tile. Group based on …1 -
Re: What is the best password policy for Encryption on Workbench
You can't use 30 different passwords to encrypt the data unless you have 30 different datasets which I highly recommend against as that's quite a bit of management overhead. Typically using…1 -
Re: Card filtering in analyzer
Have you tried using a COALESCE and filtering on the default value? COALESCE(`field`, 'Empty')2 -
Re: Can you fill null pivot table cells with the previous non null value?
Currently this isn't possible within the pivot table. You'd have to do this within an ETL to process your data.1
