What is the problem or goal the end user is trying to solve or accomplish?
The customer wants to dynamically adjust dataset queries based on the chart calling it. This would eliminate the need to create multiple dataset variations for similar queries with minor differences, simplifying dataset management and encouraging reuse.
How are they solving it currently?
Currently, the user has to create multiple datasets for each variation of the query needed by different charts. For instance:
One dataset includes AND col2='val2'
for Chart1.
Another dataset excludes AND col2='val2'
for Chart2.
What is the recommended solution by the Customer?
The customer suggests enabling datasets to detect the context (chart or dashboard) in which they are being called through a parameter or flag accessible via Jinja scripting. This would allow users to write conditional logic in the query to adjust the dataset dynamically.