Hello! We are trying to create a dashboard where the chart metrics reference
the to/from TIME RANGE specified in the filter box within a NESTED select
statement.
The parameters '{{from_dttm}}' and '{{to_dttm}}' work in the virtual SQL
dataset, but not within the nested select statement metric. We have feature
flags enabled and have also tried creating a jinja context add on for time
filter, but that also has not worked in the nested select statement.
From what I’ve heard in my GitHub discussions, I’ve been unable to determine if
this is a supported function or not. No one that I’ve spoken with has had any
success with using parameters in the metrics.
Is this something that’s supported? If so, could you provide information on how
it works (or if it will be available in the future)?
Thank you very much for your help! Any and all suggestions are appreciated 😊
-Kate
IMPORTANT NOTE: The information contained in this message may be privileged and
confidential and protected from disclosure. If the reader of this message is
not the intended recipient, or an employee or agent responsible for delivering
this message to the intended recipient, you are hereby notified that any
dissemination, distribution or copying of this communication is strictly
prohibited. If you have received this message in error, please notify the
sender immediately by replying to this message or by telephone (866-312-5646),
and delete this message. Thank you.
Disclaimer
The information contained in this communication from the sender is
confidential. It is intended solely for use by the recipient and others
authorized to receive it. If you are not the recipient, you are hereby notified
that any disclosure, copying, distribution or taking action in relation of the
contents of this information is strictly prohibited and may be unlawful.
This email has been scanned for viruses and malware, and may have been
automatically archived by Mimecast, a leader in email security and cyber
resilience. Mimecast integrates email defenses with brand protection, security
awareness training, web security, compliance and other essential capabilities.
Mimecast helps protect large and small organizations from malicious activity,
human error and technology failure; and to lead the movement toward building a
more resilient world. To find out more, visit our website.