Acombo chartis the most suitable visualization to show the value of sales for each month along with a rolling 3-month summary. The combo chart allows you to combine different types of visualizations, such as bars for monthly sales values and a line for the rolling 3-month summary. This provides a clear comparison and tracking of sales trends over time.
Key Concepts:
Rolling Summary: In this case, a 3-month rolling summary can be shown as a line measure in the combo chart, while the sales values for each month can be shown as bars.
Combo Chart: This visualization is ideal for comparing multiple measures on the same axis, such as individual sales values and aggregated rolling summaries.
Why the Other Options Are Less Suitable:
A. Scatter plot: A scatter plot is used to display the relationship between two variables, not to show time-based trends or rolling summaries.
B. Mekko chart: Mekko charts are used for categorical data and comparisons across categories, not for time-based analysis.
D. Pie chart: Pie charts are best suited for showing parts of a whole and are not appropriate for visualizing time-based data or rolling summaries.
References for Qlik Sense Business Analyst:
Combo Charts for Time Series Data: Combo charts are highly recommended when there is a need to compare different types of measures (like individual sales vs. rolling averages) over time in Qlik Sense.
Thus, acombo chartprovides the most effective solution for showing both monthly sales values and the rolling 3-month summary, makingCthe correct answer.
