Databricks Community

Amy · ‎06-23-2022

I'd like to create Gantt charts using the dashboard function. It seems like this could be possible by adding some additional parameters in the bar plot functionality, but I don't see how to do it currently (if there is a way, would love an example!).

In altair, this chart type is based on the bar plot, with an additional parameter `x2` that tells where to end the bar.

Example (from altair😞

import altair as alt
import pandas as pd
 
source = pd.DataFrame([
    {"task": "A", "start": 1, "end": 3},
    {"task": "B", "start": 3, "end": 8},
    {"task": "C", "start": 8, "end": 10}
])
 
alt.Chart(source).mark_bar().encode(
    x='start',
    x2='end',
    y='task'
)

Kaniz_Fatma · ‎06-27-2022

Hi @Amy Shapiro,

Plotly Express is the easy-to-use, high-level interface to Plotly, which operates on various types of data and produces easy-to-style figures. With a px.timeline(introduced in version 4.9), each data point is represented as a horizontal bar with a start and end point specified as dates.

By default, the px.timeline function sets the X-axis to be type=date so it can be configured like any time-series chart.

Plotly Express also supports a general-purpose px.bar function for bar charts.

For more modifications, please have a read at this article.

Amy · ‎06-27-2022

Hi @Kaniz Fatma ,

Thanks for the response. I use altair for plotting, and as you can see I can easily make the Gantt chart in python in altair using the above code. I'm specifically asking about getting this in the dashboard functionality of Databricks, which seems like it only supports Databricks plotting. Is it possible to use python to create dashboards?

Thanks,

Amy