How do I analyse a distribution or build a histogram with iDBQuery?

A distribution shows how values spread across a range, and a histogram is the picture of it, revealing whether your data clusters, skews, or has a long tail. Averages hide this; iDBQuery shows it from a simple request.

• You'd ask iDBQuery: 'Show the distribution of order values as a histogram with sensible buckets, and mark the median and average.'
• It buckets the values, counts each range, and returns a histogram plus summary statistics like median, mean, and spread.
• Each bucket is cited to its source rows, so you can click a bar and see the actual orders inside it.

Seeing the shape changes the questions you ask. Ask 'Why is there a second peak around £500?' or 'Split the distribution by customer type' and iDBQuery keeps the thread, re-bucketing as needed. Because it shows its SQL, an analyst can change bucket width or switch to a log scale in one follow-up. This is essential context for any average: a mean of £180 means something very different for a tight cluster than for a long tail, and the histogram makes that obvious. Save it as a live report, and let the Analyst agent point out where the distribution is unusually skewed or bimodal and what that implies, with the rows behind it. It pairs naturally with percentile and outlier analysis.