The timeline chart shows the evolution of the available metrics over time. It requires a Date column in the dataset.
The plot is run at the total plotted data level...
...and for each dimension.
By clicking on a legend value you can highlight that value on the charts.
SAVING THE PLOT
To save the plot as a PNG file, click on the small circle to the right of the legend, and select "save as PNG".
Open the expander under the 📊 Plot type drop down menu by clicking on the ➕ sign.
Additional options are available for selection.
By default all metrics present in the dataset are plotted. You can choose to plot only one metric, for instance "Amount".
Only the Amount plot will be plotted.
You can also change the order of the plot metrics. For instance instead of Amount, then Price, then Units, you can choose a different order
The metrics will be plotted in the required order.
By default, the four top items in terms of total Amount of the two periods are plotted, while the other items are aggregated together.
You can change the number of top items, and you can choose not to plot the value of the other aggregated items.
Values can be plotted in absolute value, as a % of total dataset, as a % of total dataset after filters, or as a % of the result row. The last two options only make sense if you plot a result row.
Resampling data means aggregating time series by a new time period. For instance this chart has monthly values, one data point per month.
We could resample it bi-monthly to get one data point every two months.
After hitting Submit the chart is smoothed out.
VS PLAN TIMELINE PLOT
If the dataset compares Actual with Plan (or similar metric) and has a Date column, the timeline plot will show the monthly difference between Actual and Plan with a "red equals bad" and "green equals good" color scheme both at the total level...
and for each dimension.
By default the app will plot only one metric, not all. You can choose which metric to plot at the dimension level with this dropdown .
CHOICE OF COLOR PALETTE
This elegant palette is both beautiful and functional.
This bright palette contains clusters with distinct color separations.
This fresh palette contains modern tones and stunning highlight colors.
BLUE & GREEN PALETTE
This contiguous palette creates a bi-chromatic chart in cool subdued hues.
KHAKI & DENIM PALETTE
This subdued palette great for complex charts.
This subdued palette is good for charts requiring contrast between segments.
HEATING UP PALETTE
This bright palette is great for complex charts.
POWERBI DEFAULT PALETTE
A lively, colorful palette.
This functional palette minimizes the risk of confusion between colors .