Visualizations make your data come to life! You can create Visualizations from any results of a query.

On Dune you can create a variety of different graphs and charts to visualize your data.

You can mix all of these graph types in one Visualization, as long as your base graph isn’t a Pie chart.

All graph Visualizations share a common set of editing options, see the tabs below for how to configure each.

all visualization configuration options

Visualization Configuration Options

This section allows you to define how to display your data.

see explanations below

Title

  • The title will appear in all instances of this graph prominently at the top.
  • The graph will always keep the name of the Query, even if you edit this.

Show chart legend

  • Ticking this box will enable or disable the legend for the chart.

Enable stacking

  • If applicable, ticking this box will stack the chart values on top of each other based on the x-axis values.
  • If this is not turned on, the values will be plotted individually on the y-axis.
  • The calculation underpinning this will always group the value corresponding to one value on the x-axis. Make sure your data is clean in able for this to work (avoid gaps in your data).

Normalize to percentage data

  • This will normalize the chart to display percentage values of the chosen data table.
  • The calculation underpinning this will always group the value corresponding to one value on the x-axis. Make sure your data is clean in able for this to work (avoid gaps in your data).

Show data labels

  • Ticking this box leads to the display of the individual datapoints inside of the graph.
  • This only makes sense in cases where you have few datapoints that are spread out far enough from each other to not overlap.

X/Y-axis Tick and Label formats

image

Tick formats change how numeric values and axis labels in your graphs are displayed.

Here’s how to format them:

Starting ValueTick/Label formatOutputDescription
1256784.3745[blank]1256784.3745000Displays the number 7 decimal precision.
1256784.374501256784Displays only the integer.
1256784.37450,01,256,784Only displays the integer with comma separation.
1256784.37450,0.001,256,784.38Displays the number with [x] decimal precision, where [x] is the number of 0 you add after the decimal point.
1256784.37450.0a1.2MDisplays the number with [x] precision and a letter based on the number’s 1e[y] power (eg “m” for million, “b” for billion)
1256784.3745$0.0a$1.2MAdds a ”$” to the number. Works with all formats above though use of the a suffix is recommended. Currently the only ”$” is the only supported currency symbol.