: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 '@testing-library/jest-dom'
import { cleanup, screen, waitFor } from '@testing-library/react'
import { getChart, hoverAtIndex, setupJsdom, setupSyncRaf } from '@posthog/quill-charts/testing'
import { buildDataVisualizationQuery, renderDataVisualization } from '~/test/insight-testing'
import { ChartDisplayType } from '~/types'
let cleanupJsdom: () => void
let cleanupRaf: () => void
beforeEach(() => {
cleanupJsdom = setupJsdom()
cleanupRaf = setupSyncRaf()
})
afterEach(() => {
cleanupRaf()
cleanupJsdom()
cleanup()
})
describe('SqlMetricCard', () => {
it('renders the latest numeric value and sparkline with SQL formatting', async () => {
const { container } = renderDataVisualization({
query: buildDataVisualizationQuery({
display: ChartDisplayType.Metric,
chartSettings: {
xAxis: { column: 'day' },
yAxis: [
{
column: 'revenue',
settings: { formatting: { style: 'number', prefix: '$', decimalPlaces: 0 } },
},
],
},
}),
response: {
columns: ['day', 'revenue'],
types: [
['day', 'Date'],
['revenue', 'Float64'],
],
results: [
['2026-01-04', null],
['2026-01-03', 1500],
['2026-01-02', null],
['2026-01-01', 1000],
],
},
})
await waitFor(() => expect(screen.getByText('$1,500')).toBeInTheDocument())
expect(screen.getByText('Jan 3, 2026')).toBeInTheDocument()
expect(container.querySelector('[data-attr="metric-sparkline"]')).toBeInTheDocument()
hoverAtIndex(getChart(container).element, 1, 3)
await waitFor(() => expect(screen.getByText('Jan 2, 2026')).toBeInTheDocument())
})
it('applies the metric settings for the headline and change pill', async () => {
renderDataVisualization({
query: buildDataVisualizationQuery({
display: ChartDisplayType.Metric,
chartSettings: {
xAxis: { column: 'day' },
yAxis: [{ column: 'revenue' }],
metric: { summary: 'total', showChange: false },
},
}),
response: {
columns: ['day', 'revenue'],
types: [
['day', 'Date'],
['revenue', 'Float64'],
],
results: [
['2026-01-01', 1000],
['2026-01-02', 1500],
],
},
})
await waitFor(() => expect(screen.getByText('2500')).toBeInTheDocument())
expect(screen.getByText('Total')).toBeInTheDocument()
expect(screen.queryByText('+50%')).not.toBeInTheDocument()
})
})