Best Of
Re: Rename filter values to "Other"
Hi @user000253
You can use a beast mode to create your custom buckets (Name 1 & Other) and use that as your quick filter.
CASE WHEN `name` = 'Name 1' THEN `name` ELSE 'Other' END
This is assuming your column is called 'name'
Re: Where I can find the "Saved post" metric in Facebook Advanced Ads Connector.
@nbrx - Glad you were able to get the metrics. If you could mark my answer as accepted so others can more easily find it in the future I'd appreciate it. Thanks!
Re: Where I can find the "Saved post" metric in Facebook Advanced Ads Connector.
Hi @nbrx - It appears the Ads Action Stats endpoint is where you can find the saved posts metric under the action_type: onsite_conversion.post_save".
You can get these with the Facebook Ads Advanced connector under:
Report: Ad Accounts
Ad Account Edge: Insights
Columns: Actions
Other settings can be assigned as needed but you'll want to filter the resulting dataset on action_type = 'onsite_conversion.post_save' to get the metric you're looking for.
Re: Beast Mode for Aging Bucket
Hi @Hiraayub
This is because you have your dates swapped. Which date is supposed to come first? You need to do your end date - your start date since the end date will be greater.
Swap `Application Started` with `Date Assigned` such that `Date Assigned` is coming first.
Re: How to get Batch_Run_ID with google sheets?
@Ashwin_SG Glad you got it sorted out! If you could accept my solution so that others who are searching for your issue could find it more easily I'd appreciate it.
Re: How to get Batch_Run_ID with google sheets?
Hi @Ashwin_SG
When you tried your recursive dataflow did you add a new column / constant contained the current date and time before your output dataset?
Re: How to get Batch_Run_ID with google sheets?
You'd need to add it to your input dataset as the first step, then when you go to add it to your recursive dataset it should have the different values stored in there for when the input is added. Do you have a screen shot of your ETL?
Re: Summary Number Format in Notebook Card
@Madz_A I'd also recommend logging an idea in the idea exchange to allow the removal of the dotted line on the notebook cards.
Re: Domo IDEAs Conference - Beast Modes - Rolling Averages
This methods assumes you have no missing weeks. If you miss a week it will cause your calculations to be incorrect. Are you attempting to calculate the rolling average across all your customers or within each customer?
Also with your SUM function the way you're calculating it now is an average of the average which isn't quite correct. You'd want to sum the lag of OT shipped first and then divide all that by the sum of the lag of your total shipped instead of 13