Density of datapoints over time

Introduction

If you have a lot of measurements on a time axis you can use the binning functions of Spotfire^® to look for the "density" of datapoints per bin.

Solution

You have to bin the x and y axis, but also the "Marker by" by both, the X and the Y axis binnings.

If you don't need it to be interactive, you can of course also pre-calculate the bins in calculated columns.

 

I used these:

BinByEvenIntervals([date],30) --> X
<BinByEvenIntervals([value],30)> --> Y
<BinByEvenIntervals([value],30) NEST BinByEvenIntervals([date],30)> --> Marker By