One numeric column
- Requirement
- Required
- Example
- Order Value 227.42
- Purpose
- Needed for the core workflow
Upload a structured file, select a numeric column, and visualize its distribution with configurable bins, ranges, and missing-value handling.
Supports structured .csv and .xlsx files. Public examples use synthetic data. Review VizMint's current privacy and retention policy before uploading sensitive information.
Use the fixed preview below to switch between the source spreadsheet and a dashboard sample. Open the full demo in a new tab for every KPI and chart.
CSV Histogram Generator
Interactive preview from the sample order-value distribution dataset
Switch preview
Total Records
160
rows in sample
Total Order Value
45,893
sum of Order Value
Total Quantity
480
sum of Quantity
Bin width 50 · 160 observations
Full dashboard with all KPI details and 6 charts is on the demo page.
Open full demoThe sample contains 160 orders across 4 categories and 3 segments. Charts and KPI cards are generated from the same JSON dataset.
Sample distribution: median $227.42, quartiles $65.94–$410.63, and 29 bins at $25 — with skew and outlier threshold published beside the histogram.
Understand the distribution of a numeric field using documented bins rather than an arbitrary chart.
A chart generator should help the user choose a valid visual, not simply draw whatever was requested. Data type, aggregation, binning, scale, and missing values determine whether the chart is honest.
The 160-order sample plots order value using $25 bins and shows the median, quartiles, skew, and outlier threshold beside the histogram.
The workflow is designed around explained chart choice, visible settings, and a supporting data table.
A histogram is for numeric distributions, not category counts. The workflow gives users control over the selected numeric field, bin count, range, outlier handling, and missing-value rules. Visualize the distribution of a numeric spreadsheet field with configurable bins.
The result brings the most important metrics, trends, and exceptions into one view, while keeping the supporting records available for review.
Follow the same dataset from source rows to the generated dashboard preview. The spreadsheet table, KPI cards, and charts all come from one JSON sample, so every visible result can be checked against the source.
The source preview highlights the exact columns and representative rows used by the workflow.
| Date | Quarter | Category | Region | Order Value |
|---|---|---|---|---|
| 2025-07-01 | Q3 2025 | Accessories | North America | 48.1 |
| 2025-08-01 | Q3 2025 | Training | North America | 179.1 |
| 2025-09-01 | Q3 2025 | Software | North America | 366.3 |
| 2025-10-01 | Q4 2025 | Services | Europe | 700.5 |
| 2025-11-01 | Q4 2025 | Accessories | Europe | 56.1 |
The finished output includes the KPI cards, charts, tables, and report views described below.
Bin width 50 · 160 observations
VizMint works best when every column has one clear heading and each row represents one consistent record. Fields that are not available should not be invented; dependent outputs should be hidden or clearly marked as unavailable.
| Column | Requirement | Example | Purpose |
|---|---|---|---|
| One numeric column | Required | Order Value 227.42 | Needed for the core workflow |
| Category for optional filtering | Recommended | Marketing | Adds an important comparison or breakdown |
| Clear numeric formatting | Recommended | 366.26 | Adds an important comparison or breakdown |
| Date | Optional | 2026-06-01 | Adds detail when present |
| Segment | Optional | SMB | Adds detail when present |
| Unit Label | Optional | USD | Adds detail when present |
Count of numeric values included after missing and non-numeric values are excluded.
Count of blank or invalid cells reported separately from the distribution.
The arithmetic average of the selected numeric observations.
The middle value after the observations are sorted.
The smallest valid value in the selected data.
The largest valid value in the selected data.
A measure of how widely the values are spread around the mean.
The number of intervals used to group valid observations in the histogram.
| Chart or Output | Required Fields | Business Question |
|---|---|---|
| Frequency Histogram | Selected numeric field and bin settings | How are values distributed across intervals? |
| Percentage Histogram | Selected numeric field and bin settings | What share of observations falls in each bin? |
| Filtered Distribution | Numeric field plus optional category or segment filter | How does the distribution change after filtering? |
| Distribution by Segment | Numeric field and segment or category | How do distributions differ between groups? |
Upload the workflow-specific sample or a user file.
Select the correct worksheet when the workbook contains multiple sheets.
Confirm the detected header row and field mapping.
Review the data preview, exclusions, and validation warnings.
Generate the dashboard, chart, report, presentation, or answer.
Review KPI values, calculations, charts, and source traceability.
Save, share, or export using capabilities available on the active plan.
| Metric | Formula or Method | Required Fields | Important Rule |
|---|---|---|---|
| Mean | Sum of valid values / valid observations | Selected numeric column | Exclude missing and non-numeric values. |
| Median | Middle value after sorting valid observations | Selected numeric column | Use standard even-count handling. |
| Bin Frequency | Count of values within each bin interval | Selected numeric column and bin edges | Bin edges and inclusivity must be consistent. |
| Problem | Recommended Fix |
|---|---|
| Numbers stored as text | Convert numeric values to numbers and remove symbols or spaces that block calculations. |
| Too few valid values | Document the rule, standardize the source data, and validate the corrected result before generation. |
| Extreme outliers | Document the rule, standardize the source data, and validate the corrected result before generation. |
| Mixed units | Document the rule, standardize the source data, and validate the corrected result before generation. |
| Zeros used for missing values | Add the missing field when available; otherwise hide dependent metrics and explain the limitation. |
Available sharing and export options depend on the live VizMint plan. Publish only capabilities confirmed in production, such as saving the analysis, downloading images or PDF files, exporting PowerPoint, creating private links, refreshing a saved report, or removing branding on eligible plans.
Do not hardcode plan limits, file-size limits, privacy promises, or export features until product and billing owners confirm them.
VizMint analyzes exports; it does not replace the accounting, CRM, help-desk, HR, warehouse, advertising, or project-management system that produced them.
Upload a structured CSV or Excel file to generate the supported metrics, charts, and comparisons for this workflow.