Creating Visualizations (Charts)

The video provides a guide on how to create and customize visualizations on the Dune platform after writing a query. Key points include:

  1. Overview of Visualizations: The video introduces different visualization types, including charts, tables, and more, explaining how each can be formatted, including axes, legends, and colors.
  2. Formatting and Customization: Users learn how to format raw query results, such as renaming columns, adding dollar signs, rounding values, and adjusting number formats for readability. The video also covers how to customize visualization elements like colors, legends, and titles.
  3. Creating and Editing Charts: The video walks through creating new visualizations, like bar charts, selecting X and Y axes, and grouping data. It shows how to stack items for better readability and customize tooltips for detailed hover information.
  4. Color and Legend Management: Users can manage default colors assigned to legend items, override them with custom colors, and rearrange legend items for better visual order.
  5. Advanced Chart Features: The video covers features like normalizing bar charts to percentages, combining different chart types (e.g., line and scatter), and the importance of starting with a bar chart before changing to other types to maintain stacking functionality.
  6. Adding Descriptions and Parameters: Users can add descriptions to visualizations and use parameters within these descriptions to dynamically update based on the data.
  7. Final Steps: Once a visualization is created, it can be added to any dashboard as a widget. Users can delete or modify visualizations as needed.

Overall, the video aims to equip users with the skills to effectively create, customize, and manage visualizations on Dune to better present their data.

Transcript