Bucket the results into time periods over the date range
TIMESERIES breaks your results into time buckets across the date range, so you can see how a metric moves over time. Choose one grain: day, week, or month.
FROM sales SHOW total_revenue TIMESERIES week DURING last_quarter
Each bucket in the range gets a row, including quiet periods with no activity, so a line or bar chart reads as a continuous trend. Pair it with a date clause to set the window, such as DURING above.A timeseries is a single trend across your whole shop, so it cannot be combined with GROUP BY. To plot the trend as a chart, add VISUALIZE with a line or bar type, and to overlay events like restocks or stockouts use ANNOTATE.
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"Stockful","colors":{"primary":"#E8552B","light":"#F1774F","dark":"#C4431F"},"logo":{"light":"https://mintcdn.com/ljsstudios/tBVtzZCERvi3LxkY/logo/docs-logo-light.png?fit=max\u0026auto=format\u0026n=tBVtzZCERvi3LxkY\u0026q=85\u0026s=78ae1213a2333bef6f0e7bfd4cc6c12c","dark":"https://mintcdn.com/ljsstudios/tBVtzZCERvi3LxkY/logo/docs-logo-dark.png?fit=max\u0026auto=format\u0026n=tBVtzZCERvi3LxkY\u0026q=85\u0026s=90644d686b246934bbe46ae133ad19b5"},"favicon":"https://mintcdn.com/ljsstudios/tBVtzZCERvi3LxkY/favicon.svg?fit=max\u0026auto=format\u0026n=tBVtzZCERvi3LxkY\u0026q=85\u0026s=70949a4c61a7c929910860d6be1fc8ef","navbar":{"links":[{"href":"/support","label":"Support"},{"href":"https://apps.shopify.com/stockful-inventory-management?utm_source=stockful-docs\u0026utm_medium=docs\u0026utm_content=header-install","label":"Install Stockful"}]},"footer":{"socials":{"website":"https://apps.shopify.com/stockful-inventory-management?utm_source=stockful-docs\u0026utm_medium=docs\u0026utm_content=footer-globe"},"links":[{"header":"Help","items":[{"label":"Contact Support","href":"/support"},{"label":"FAQs","href":"/user-guide/faqs"}]},{"header":"Policies","items":[{"label":"Privacy Policy","href":"/policies/privacy-policy"},{"label":"Terms of Service","href":"/policies/terms-of-service"},{"label":"Data Processing Agreement","href":"/policies/data-processing-agreement"},{"label":"Security Incident Response","href":"/policies/security-incident-response"}]}]},"search":{"prompt":"Search Stockful documentation"},"seo":{},"fonts":{"heading":{"family":"JetBrains Mono"},"body":{"family":"Inter"}},"contextual":{"options":["copy","view","chatgpt","claude"],"display":"header"},"styling":{"latex":false},"navigation":{"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"ljsstudios","hasAudioNarration":false,"actualSubdomain":"ljsstudios","customDomains":["docs.stockful.app"],"gitSource":{"type":"github","owner":"lspoor","repo":"stockful","deployBranch":"main","contentDirectory":"documentation","isPrivate":true,"mountPath":"","label":""},"entitlements":{},"buildId":"6af9a5377fd385b08ebecb92","clientVersion":"0.0.4167","searchFilterCounts":[{"language":"default","tag":"User Guide","count":78},{"language":"default","tag":"StockfulQL","count":39},{"language":"default","tag":"Datasets","count":24},{"language":"default","tag":"Purchasing","count":22},{"language":"default","tag":"Using Stockful","count":19},{"language":"default","tag":"Syntax","count":13},{"language":"default","tag":"Delivery channels","count":11},{"language":"default","tag":"Reports","count":11},{"language":"default","tag":"Alerts","count":9},{"language":"default","tag":"Storefront","count":8}]},"assistantConfig":{"enableAskAiButton":false,"enableStarterQuestions":false,"enableAskAiSearchBar":true},"basePath":"","hasChatPermissions":false,"hasWebMcpPermissions":false,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-rbac-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-metadata","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":true},"customCss":[],"page":{"pagePath":"stockfulql/syntax/timeseries","slug":"/stockfulql/syntax/timeseries","pageMetadata":{"title":"TIMESERIES","description":"Bucket the results into time periods over the date range","href":"/stockfulql/syntax/timeseries"},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"Bucket the results into time periods over the date range\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={a:`a`,code:`code`,p:`p`,pre:`pre`,span:`span`,..._provideComponents(),...props.components},{CodeBlock}=_components;if(!CodeBlock)_missingMdxReference(`CodeBlock`,true);return _jsxs(_Fragment,{children:[_jsxs(_components.p,{children:[_jsx(_components.code,{children:`TIMESERIES`}),` breaks your results into time buckets across the date range, so you can see how a metric moves over time. Choose one grain: `,_jsx(_components.code,{children:`day`}),`, `,_jsx(_components.code,{children:`week`}),`, or `,_jsx(_components.code,{children:`month`}),`.`]}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`4`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`4`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`FROM`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` sales`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` SHOW total_revenue`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` TIMESERIES `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`week`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` DURING last_quarter`})}),`\n`]})})}),`\n`,_jsxs(_components.p,{children:[`Each bucket in the range gets a row, including quiet periods with no activity, so a line or bar chart reads as a continuous trend. Pair it with a date clause to set the window, such as `,_jsx(_components.a,{href:`/stockfulql/syntax/since-until-during`,children:`DURING`}),` above.`]}),`\n`,_jsxs(_components.p,{children:[`A timeseries is a single trend across your whole shop, so it cannot be combined with `,_jsx(_components.a,{href:`/stockfulql/syntax/group-by`,children:`GROUP BY`}),`. To plot the trend as a chart, add `,_jsx(_components.a,{href:`/stockfulql/syntax/visualize`,children:`VISUALIZE`}),` with a `,_jsx(_components.code,{children:`line`}),` or `,_jsx(_components.code,{children:`bar`}),` type, and to overlay events like restocks or stockouts use `,_jsx(_components.a,{href:`/stockfulql/syntax/annotate`,children:`ANNOTATE`}),`.`]})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"TIMESERIES","description":"Bucket the results into time periods over the date range","href":"/stockfulql/syntax/timeseries"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[],"codeExamples":{}},"jsLinks":[],"subdomain":"ljsstudios","siteName":"Stockful","title":"TIMESERIES - Stockful","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-08-15T18:08:25.396Z","originalFileLocation":"stockfulql/syntax/timeseries.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"system\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"Bucket the results into time periods over the date range\">\u003cmeta data-mint-head name=\"application-name\" content=\"Stockful\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/ljsstudios/kERyKf82rkLAv8fJ/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/ljsstudios/kERyKf82rkLAv8fJ/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/ljsstudios/kERyKf82rkLAv8fJ/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/ljsstudios/kERyKf82rkLAv8fJ/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/ljsstudios/kERyKf82rkLAv8fJ/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/ljsstudios/kERyKf82rkLAv8fJ/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/ljsstudios/kERyKf82rkLAv8fJ/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/ljsstudios/kERyKf82rkLAv8fJ/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/ljsstudios/kERyKf82rkLAv8fJ/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"TIMESERIES - Stockful\">\u003cmeta data-mint-head property=\"og:description\" content=\"Bucket the results into time periods over the date range\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Stockful\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.stockful.app/stockfulql/syntax/timeseries\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://ljsstudios.mintlify.site/_mintlify/api/og/v2?division=Syntax\u0026amp;title=TIMESERIES\u0026amp;description=Bucket+the+results+into+time+periods+over+the+date+range\u0026amp;theme=3477247c7c3aace17cf60e22\u0026amp;signature=d9fc1b5e3288495eb160822415bb4a10fd9d05a9f79d73bca7cae730978a5965\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"TIMESERIES - Stockful\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Bucket the results into time periods over the date range\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://ljsstudios.mintlify.site/_mintlify/api/og/v2?division=Syntax\u0026amp;title=TIMESERIES\u0026amp;description=Bucket+the+results+into+time+periods+over+the+date+range\u0026amp;theme=3477247c7c3aace17cf60e22\u0026amp;signature=d9fc1b5e3288495eb160822415bb4a10fd9d05a9f79d73bca7cae730978a5965\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/ljsstudios/kERyKf82rkLAv8fJ/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Stockful\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#E8552B\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.stockful.app/stockfulql/syntax/timeseries\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/stockfulql/syntax/timeseries.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.stockful.app/#organization\",\"name\":\"Stockful\",\"url\":\"https://docs.stockful.app\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/ljsstudios/tBVtzZCERvi3LxkY/logo/docs-logo-light.png?fit=max\u0026auto=format\u0026n=tBVtzZCERvi3LxkY\u0026q=85\u0026s=78ae1213a2333bef6f0e7bfd4cc6c12c\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.stockful.app#website\",\"name\":\"Stockful\",\"url\":\"https://docs.stockful.app\",\"publisher\":{\"@id\":\"https://docs.stockful.app/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.stockful.app/stockfulql/syntax/timeseries#webpage\",\"url\":\"https://docs.stockful.app/stockfulql/syntax/timeseries\",\"name\":\"TIMESERIES\",\"description\":\"Bucket the results into time periods over the date range\",\"dateModified\":\"2026-08-15T18:08:25.396Z\",\"isPartOf\":{\"@id\":\"https://docs.stockful.app#website\"},\"breadcrumb\":{\"@id\":\"https://docs.stockful.app/stockfulql/syntax/timeseries#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.stockful.app/stockfulql/syntax/timeseries#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Syntax\",\"item\":\"https://docs.stockful.app/stockfulql/syntax/overview\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"TIMESERIES\",\"item\":\"https://docs.stockful.app/stockfulql/syntax/timeseries\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.stockful.app/stockfulql/syntax/timeseries#article\",\"headline\":\"TIMESERIES\",\"name\":\"TIMESERIES\",\"description\":\"Bucket the results into time periods over the date range\",\"url\":\"https://docs.stockful.app/stockfulql/syntax/timeseries\",\"mainEntityOfPage\":{\"@id\":\"https://docs.stockful.app/stockfulql/syntax/timeseries#webpage\"},\"dateModified\":\"2026-08-15T18:08:25.396Z\",\"publisher\":{\"@id\":\"https://docs.stockful.app/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.stockful.app#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Stockful\",\"publisher\":{\"@type\":\"Organization\",\"name\":\"Stockful\"},\"provider\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","agentPointerHref":"/stockfulql/syntax/timeseries.md","siteName":"Stockful","nav":{"global":null,"tabs":[{"tab":"User Guide","pages":[{"title":"User Guide","href":"/user-guide/getting-started"}]},{"tab":"StockfulQL","groups":[{"group":"Introduction","icon":"book-open","pages":[{"title":"StockfulQL","href":"/stockfulql/overview"}]},{"group":"Syntax","icon":"code","pages":[{"title":"Overview","href":"/stockfulql/syntax/overview"},{"title":"FROM and SHOW","href":"/stockfulql/syntax/from-and-show"},{"title":"WHERE","href":"/stockfulql/syntax/where"},{"title":"GROUP BY","description":"Break the results down by one or more dimensions","href":"/stockfulql/syntax/group-by"},{"title":"TIMESERIES","href":"/stockfulql/syntax/timeseries"},{"title":"WITH","description":"Add result modifiers like totals, subtotals, percent change, and running totals","href":"/stockfulql/syntax/with"},{"title":"HAVING","href":"/stockfulql/syntax/having"},{"title":"SINCE, UNTIL and DURING","href":"/stockfulql/syntax/since-until-during"},{"title":"COMPARE TO","href":"/stockfulql/syntax/compare-to"},{"title":"ORDER BY","href":"/stockfulql/syntax/order-by"},{"title":"LIMIT","href":"/stockfulql/syntax/limit"},{"title":"VISUALIZE","href":"/stockfulql/syntax/visualize"},{"title":"ANNOTATE","href":"/stockfulql/syntax/annotate"}]},{"group":"Datasets","icon":"database","pages":[{"title":"Overview","href":"/stockfulql/datasets/overview"},{"group":"Inventory","pages":[{"title":"Inventory","href":"/stockfulql/datasets/inventory"}]},{"group":"Sales","pages":[{"title":"Sales","href":"/stockfulql/datasets/sales"},{"title":"Orders","href":"/stockfulql/datasets/orders"},{"title":"Sales trends","href":"/stockfulql/datasets/sales_history"},{"title":"Returns","href":"/stockfulql/datasets/returns"},{"title":"Promotions","href":"/stockfulql/datasets/promo"}]},{"group":"Purchasing","pages":[{"title":"Purchasing","href":"/stockfulql/datasets/purchasing"},{"title":"Purchase costs","href":"/stockfulql/datasets/purchase_costs"},{"title":"Cost history","href":"/stockfulql/datasets/cost_history"},{"title":"Goods receipts","href":"/stockfulql/datasets/receipts"},{"title":"Supplier performance","href":"/stockfulql/datasets/supplier_performance"}]},{"group":"Replenishment","pages":[{"title":"Reorder history","href":"/stockfulql/datasets/reorder_history"},{"title":"Reorder (all locations)","href":"/stockfulql/datasets/reorder_consolidated"},{"title":"Transfer history","href":"/stockfulql/datasets/transfer_history"},{"title":"Transfer suggestions","href":"/stockfulql/datasets/transfer_suggestions"}]},{"group":"Operations","pages":[{"title":"Stock adjustments","href":"/stockfulql/datasets/adjustments"},{"title":"Pricing","href":"/stockfulql/datasets/price_history"},{"title":"Forecast accuracy","href":"/stockfulql/datasets/forecast_runs"}]},{"group":"Production","pages":[{"title":"Raw materials","href":"/stockfulql/datasets/materials"},{"title":"Material movements","href":"/stockfulql/datasets/material_movements"},{"title":"Production","href":"/stockfulql/datasets/production"}]},{"group":"Traffic","pages":[{"title":"Storefront traffic","href":"/stockfulql/datasets/traffic"},{"title":"Storefront search","href":"/stockfulql/datasets/search"}]}]},{"group":"Examples","icon":"lightbulb","pages":[{"title":"Examples","href":"/stockfulql/examples"}]}]},{"tab":"Storefront","pages":[{"title":"Storefront","href":"/storefront/overview"}]},{"tab":"Changelog","pages":[{"title":"Changelog","href":"/changelog"}]},{"tab":"Policies","pages":[{"title":"Policies","href":"/policies/privacy-policy"}]}]},"basePath":"","title":"TIMESERIES - Stockful","buildId":"dpl_9RFrWkXdFTJCytfx6jAofvAaEXr6","deploymentId":"dpl_9RFrWkXdFTJCytfx6jAofvAaEXr6","dynamics":[],"chunks":[]}