Data through 'date' at a tab level

[Asuji1]

Hello friends,
I would like to add 'Data through ' in a tab at the bottom. The should be dynamically updated with the max(date) in my dataset. How should I go about doing this? I don't want to do it in a table or text chart. Don't want it to be interactive. If you have other recommendations for the position of this message, then do let me know.
Thanks in advance.

[dosubot[bot]]

Hey @Asuji1, I'm here to help you out with any bugs or questions you have. I'm a bot designed to assist you with problem-solving and becoming a contributor. Let me know how I can assist you with the issue you're facing.

I found a similar unsolved discussion titled Selecting the latest date from the database ^[1].

To dynamically update text with the maximum date from your dataset in Apache Superset, you can use Jinja templating. First, ensure that the ENABLE_TEMPLATE_PROCESSING feature flag is set in your superset_config.py. You can then use Jinja macros to extract the maximum date from your dataset.

Here's a general approach you can take:

1. Enable Jinja Templating: Make sure the ENABLE_TEMPLATE_PROCESSING is enabled in your configuration.

2. Use Jinja in SQL Queries: You can write a SQL query to get the maximum date and use Jinja to insert this value into your dashboard. For example:

   SELECT MAX(date_column) AS max_date FROM your_table

3. Display the Date: Use a Markdown box or another component to display the date. You can use Jinja to insert the date dynamically:

   Data through {{ max_date }}

4. Positioning: Since you don't want it in a table or text chart, consider using a Markdown box at the desired position in your dashboard. You can customize the layout and positioning of components in your dashboard to place the Markdown box at the bottom ^[2].

This approach allows you to display the maximum date dynamically without using a table or text chart.

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Other}

[Asuji1]

@dosu this did not work. I changed the Feature flag, saved the query and tried to access it exactly like you mentioned. Any other suggestions?

[dosubot[bot]]

To dynamically display the maximum date from your dataset in Apache Superset without using a table or text chart, you can try the following approach:

1. Ensure Jinja Templating is Enabled: Double-check that the ENABLE_TEMPLATE_PROCESSING feature flag is set to True in your superset_config.py.

2. Create a Virtual Dataset: Use SQL Lab to create a virtual dataset that calculates the maximum date. For example:

   SELECT MAX(date_column) AS max_date FROM your_table

3. Use a Markdown Component: Although you mentioned not wanting to use a table or text chart, a Markdown component is a flexible option for displaying text. Unfortunately, Superset does not natively support dynamic Jinja rendering in Markdown components directly. However, you can manually update the Markdown content with the maximum date obtained from your virtual dataset.

4. Alternative Approach: If you need the date to update automatically without manual intervention, consider using a custom visualization plugin or embedding a small web application that fetches and displays the date dynamically.

These steps should help you achieve your goal of displaying the maximum date dynamically. If you have further questions or need more detailed guidance, feel free to ask!

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Other}

[Asuji1]

@dosu Can you help me with 4. Alternative Approach: If you need the date to update automatically without manual intervention, consider using a custom visualization plugin or embedding a small web application that fetches and displays the date dynamically. Please elaborate on both visual plugin and the web application

[dosubot[bot]]

To achieve automatic updates of the maximum date without manual intervention, you can consider two approaches: creating a custom visualization plugin or embedding a small web application. Here's how you can proceed with each:

1. Custom Visualization Plugin:

   • Prerequisites: Ensure you have Node.js, npm, and a development environment set up for Superset. Familiarity with React is also beneficial.

   • Create a Plugin:

     • Use the Superset Yeoman generator to scaffold a new plugin.
     • Navigate to the superset-frontend/packages/generator-superset directory and run the generator to create a new plugin.
     • Implement the logic to fetch the maximum date from your dataset within the plugin. You can use Superset's API or a direct database query to retrieve this data.

   • Build and Integrate:

     • Build the plugin using npm run build.
     • Integrate the plugin into Superset by adding it to the MainPreset.js file in the superset-frontend directory.
     • Run Superset to see your plugin in action.

   This approach allows you to create a reusable component that can be added to any dashboard.

2. Embedding a Small Web Application:

   • Develop a Web Application:

     • Create a simple web application using a framework like React, Angular, or Vue.js.
     • Implement the logic to fetch the maximum date from your dataset. This can be done using an API call to your database or Superset's API.

   • Embed in Superset:

     • Use an iframe or a similar method to embed the web application within a Superset dashboard.
     • Ensure that the web application is hosted on a server accessible by Superset and that CORS policies are configured correctly.

   • Security Considerations:

     • Configure CORS and Content Security Policy (CSP) settings in Superset to allow embedding of your web application.
     • Ensure that the web application is secure and follows best practices for data fetching and display.

Both approaches allow for dynamic updates of the maximum date, with the custom visualization plugin being more integrated into Superset, while the web application offers more flexibility in terms of design and functionality.

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Other}