How to show a jinja variable value in legend of a plot or in seperate textfield in dashboard?

[franzislytics]

Hi,

In my dashboard I am using a jinja variable as a filter to show a plot depending on which value is choosen in the filter.

Problem: Now in the plot is only shown the general name of the variable in the legend and at the plot.

Example: Variable "KPI" with values "A" and "B", in plot legend is shown "KPI".

Goal:

• Option 1: I would like to see "A" or "B" in the legend/at the plot, depending which value is choosen in the filter.

• Option 2 would be to print the value in a seperate text field, where I can just show something like: "Choosen value: A".

[dosubot[bot]]

Hey @franzislytics! 👋 I'm here to help you with all things code, bugs, and more. Let's squash those bugs together!

To show a Jinja variable value in the legend of a plot or in a separate text field in a dashboard, depending on the chosen filter value, you can use the filter_values function provided in Apache Superset.

Here is an example of how you can achieve this:

1. Retrieve the Filter Value:
   Use the filter_values function to get the value of the selected filter.

   {% set filter_value = filter_values('your_filter_column_name')[0] %}

2. Display in a Text Field:
   You can then use filter_value in a text field in your dashboard.

   <div>
       Chosen value: {{ filter_value }}
   </div>

3. Display in Plot Legend:
   To include the filter value in the plot legend, you might include it in the title or subtitle of the plot.

   import matplotlib.pyplot as plt
   
   # Example plot
   plt.plot([1, 2, 3], [4, 5, 6])
   plt.title(f"Plot Title - Filter: {filter_value}")
   plt.legend([f"Legend - Filter: {filter_value}"])
   plt.show()

This way, the value of the filter applied to your_filter_column_name will be dynamically displayed in the legend or text field based on the chosen filter value ^[1].

To continue talking to Dosu, mention @dosu.