GrantSmith Coach 
-
Re: Average Time between Orders
If you're looking to do this per customer you can utilize a Rank & Window tile and use the LAG function to get the prior record's value. You'll want to partition based on the custo…1 -
Re: Is there a way to count all views of a card, including dashboard views?
Page views and Card views are separate from each other in the activity log. You'd need to utilize an ETL to join the governance dataset for cards and pages to the page ID in the activity log and…1 -
Re: Adding filtered count to dynamic text box
Have you tried using a beast mode to calculate the difference between now and 5 days ago and counting them? COUNT(CASE WHEN `date_field` < CURRENT_DATE() - INTERVAL 5 DAY THEN `date_field` END)1 -
Re: can you share a filter view if you don't co-own the page?
Correct, this is because the page is locked to prevent editing from anyone except for admins and the page owner (the lock symbol next to your Keyword Performance title).1 -
Re: Case Statement with Count Distinct
Yes, you'd need to utilize a group by function. You can either use a function in the group by or use a formula tile to put your CASE statement in and then do a distinct count with a group by til…1
