Best Of

Thanks for the step by step guide @Godiepi, I think what I was missing was linking the beast mode dates to the specific value cards in the date settings. It's working now as you describe. Thanks for the solution here and walking me through it.

@Kailin Do you have a drill path configured on the card? The Drill in Place option does not go down to the raw data table, so you will have to configure a Mega Table or HTML table in the drill to see the detail in order to drill from the dashboard.

@bradw I understand the process to make it work is a little difficult. let me layout for you by step

You are working with [Order Created Date] for your filter and [Sales Amount] for you single value card

1. Create 2 Beastmodes around [Order Created Date]as follows :
   1. Beastmode 1 = [Order Created Date1] formula = DATE(`Order Created Date`)
   2. Beastmode 2 = [Order Created Date2] formula = Date(`Order Created Date`)
2. Create 2 Date Selector cards as follows
   1. Card 1
      1. Name = Date Selector1
      2. Card Type = Filter Date Selector using beastmode field [Order Created Date1]
      3. Make sure in analyzer that the date range field in use is [Order Created Date1]
   2. Card 2
      1. Name = Date Selector2
      2. Card Type = Filter Date Selector using beastmode field [Order Created Date2]
      3. Make sure in analyzer that the date range field in use is [Order Created Date2]
3. Since you already have the single value cards showing the sum of amount created as Date 1 Sales and Date 2 Sales, the only step here is :
   1. Open Date 1 Sales in analyzer
      1. Go to the right upper corner and adjust the date range field to use [Order Created Date1]and saved.
   2. Open Date 2 Sales in analyzer
      1. Go to the right upper corner and adjust the date range field to use [Order Created Date2]and saved.
4. Place the 4 cards in the dashboard
5. On the dashboard page go to the wrench icon (Dashboard settings) and choose the last option at the bottom Filter Options to uncheck the option of Allow Global Date Filters
6. Go to the dashboard settings again and adjust the interaction of each Date Selector to only affect one of the cards
   1. Date Selector1 apply to only Date 1 Sales
   2. Date Selector2 apply to only Date 2 Sales

Let me know if you still can't get it to work because it works for me just fine. if you still have issues I dont mind jumping on a quick call to walk you through.

@bradw You can created 2 Filter cards, locate them on top of each of the cards in your dashboard, then adjust the interaction settings so that [Date selector 1] only filters the card [Date 1 sales] and [Date selector 2] only filters the card [Date 2 sales] within your dashboard... that's the only way you can do that

@bradw you have to adjust the interaction on each selector independently to enable interaction filters to ONLY apply to selected cards. clicking on CHANGE will open the list of all the cards in your dashboard, from there you can select the specific card.

You want selector1 to only interact with Card1 .... and Selector2 to only interact with Card2

It is very tricky as you have to turn off the Date filtering Global settings

Try also creating 2 beastmodes for the same date DATE() but name them differently. also in the cards to filter make sure the date column they use is the beastmode for each.

you should be able to get this:

Hi @hmicm yes, there is a "Drill In Place" option on the card Interaction settings. You can access this via "Edit Dashboard" - "Edit Content" - "Change Interaction"