QuestionQ2
Working with Dashboards and Visualizations in DatabricksA BI analyst is creating a Databricks SQL dashboard to monitor monthly revenue for three product categories over two years. Leadership needs a chart that makes it easy to compare each category’s trend over time and rapidly identify seasonal patterns or declines without using extra filters or calculations.
Which Databricks SQL visualization type will clearly convey the described revenue trends and category comparisons?
- A Multi-series line chart plotting month on the x-axis and revenue on the y-axis for each category.
- B Single-value counter displaying combined revenue for the entire two-year period.
- C Pie chart showing each category’s percentage of total revenue for the final month.
- D Scatter chart with revenue on the x-axis and profit margin on the y-axis for all transactions.
Community Discussion