Set Date Based Upon Field Value in Client Dashboard Extend

Ask the Community
1

I want to automatically set a date filter on an extended dashboard based upon the “Live Date” dimension value. Is this possible?

2

Hi Chuck,

Could you please elaborate on your use case so we can better understand it?

Regards

3

There is a field called “Live Date” and that value determines the start of the reporting date range for the dashboard. While we can set it manually, it would be better to set the date ‘matches’ start date based upon that field value. And, ideally the end date based on a formula. For example, n the client dashboard we are using the following:

block f3: master_client_bot_conversation_dashboard_template.block.f3.extend ({
default {
operator: ‘matches’
value: ‘2024-06-05 - 2025-06-30’

The start date above (2024-06-05) value comes from the ‘live date’ field. The end date should actually be the ‘live date + 365’. Does that help explain the use case?

4

Hi Chuck,

Sorry for the late response. Unfortunately, AML is processed before any data processing is done so we can’t dynamically update AML during runtime. Your suggestion is valuable, though! We’ve added this feature to our product backlog for further evaluation with our development team. We’ll reach out to you directly once we have a solution or alternative approach available.

Thank you for your patience and for helping us improve our product.