Displaying histogram data with the bar chart visualization
It turns out the answer to the first question is yes. Again, we can leverage transformations to shape our data in a way that makes it compatible with the bar chart. At this point, we’re going to break away from the pattern we’ve followed in this chapter in order to demonstrate a better workflow practice than simply creating the bare minimum to illustrate a concept.
The goal is to set up a visualization pipeline, both the Query and the Transform, to maximize our flexibility as we perform analysis. This way, if we want to produce multiple panels with different slices of data or different metrics, we don’t have to create entirely new panels each time. Follow these steps:
- Create a new bar chart visualization panel.
- Add the following query (raw editor):
SELECT "magnitude", "cdi", "mmi", "sig", "depth" FROM "event" WHERE $timeFilter GROUP...