:hedgehog: PostHog is the leading platform for building self-driving products. Our developer tools – AI observability, analytics, session replay, flags, experiments, error tracking, logs, and more – capture all the context agents need to diagnose problems, uncover opportunities, and ship fixes. Steer it all from Slack, web, desktop, or the MCP.
Python ab-testingai-analyticsanalyticscdpdata-warehouseexperimentsfeature-flagsjavascriptproduct-analyticspythonreactsession-replaysurveystypescriptweb-analytics
import clsx from 'clsx'
import { useMemo } from 'react'
import {
ScatterChart,
ScatterChartConfig,
ScatterAreaSelection,
ScatterPointDatum,
ChartLegendConfig,
} from '@posthog/quill-charts'
import { makeChartErrorHandler } from 'lib/charts/chartErrorHandler'
import { useChartConfig, useChartTheme } from 'lib/charts/hooks'
import { ChartSettings } from '~/queries/schema/schema-general'
import { AxisSeries } from '../../dataVisualizationLogic'
import { buildScatterConfig, buildScatterSeries, SqlScatterSeries, SqlScatterPointMeta } from './sqlScatterGraphAdapter'
const handleChartError = makeChartErrorHandler('sql-scatter-chart')
export interface SqlScatterGraphProps {
/** The x column. Both axes are continuous, so a non-numeric column has nothing to plot. */
xData: AxisSeries<string> | null
yData: AxisSeries<number | null>[]
chartSettings: ChartSettings
presetChartHeight?: boolean
className?: string
series?: SqlScatterSeries[]
legendVisibility?: Pick<ChartLegendConfig, 'hiddenKeys' | 'onToggleSeries' | 'onSetHiddenSeries'>
viewport?: ScatterAreaSelection | null
isPointHighlighted?: ScatterChartConfig<SqlScatterPointMeta>['isPointHighlighted']
onPointClick?: (point: ScatterPointDatum<SqlScatterPointMeta>) => void
onAreaSelect?: (selection: ScatterAreaSelection) => void
}
/** SQL scatter plot on @posthog/quill-charts' {@link ScatterChart} — one series per selected Y
* column, one marker per result row. */
export const SqlScatterGraph = ({
xData,
yData,
chartSettings,
presetChartHeight,
className,
series: suppliedSeries,
viewport,
legendVisibility,
onPointClick,
onAreaSelect,
isPointHighlighted,
}: SqlScatterGraphProps): JSX.Element => {
const theme = useChartTheme()
const series = useMemo(() => suppliedSeries ?? buildScatterSeries(xData, yData), [suppliedSeries, xData, yData])
const baseConfig = useMemo(
() => (xData ? buildScatterConfig({ xData, yData, chartSettings }) : undefined),
[xData, yData, chartSettings]
)
const config = useChartConfig((): ScatterChartConfig<SqlScatterPointMeta> | undefined => {
if (!baseConfig) {
return undefined
}
const base = { ...baseConfig, legend: { ...baseConfig.legend, ...legendVisibility }, isPointHighlighted }
return viewport
? { ...base, xAxis: { ...base.xAxis, domain: viewport.x }, yAxis: { ...base.yAxis, domain: viewport.y } }
: base
}, [baseConfig, viewport, legendVisibility, isPointHighlighted])
const hasPoints = series.some((s) => s.points.length > 0)
if (!hasPoints || !config) {
return (
<div className={clsx(className, 'rounded bg-surface-primary flex flex-1 items-center justify-center p-6')}>
<span className="text-secondary text-sm">
No points to plot. Pick a numeric column for each axis, and make sure some rows have a value in
both.
</span>
</div>
)
}
return (
<div
className={clsx(
className,
'rounded bg-surface-primary w-full grow relative overflow-hidden flex flex-col',
{ 'h-[60vh]': presetChartHeight, 'h-full': !presetChartHeight }
)}
>
<ScatterChart
series={series}
theme={theme}
config={config}
dataAttr="sql-scatter-chart"
onError={handleChartError}
onPointClick={onPointClick}
onAreaSelect={onAreaSelect}
/>
</div>
)
}