{"id":1646,"date":"2026-11-17T16:28:11","date_gmt":"2026-11-17T14:28:11","guid":{"rendered":"https:\/\/www.kaarne.fi\/superstore\/?p=1646"},"modified":"2026-11-17T16:28:11","modified_gmt":"2026-11-17T14:28:11","slug":"service-report-date-boundary","status":"publish","type":"post","link":"https:\/\/www.kaarne.fi\/superstore\/articles\/service-report-date-boundary\/","title":{"rendered":"Which Date Does Your Service Report Mean?"},"content":{"rendered":"<p>\u201cShow me last week\u2019s cases\u201d sounds precise until two colleagues produce different lists. One selects the date a request arrived. The other selects the date the work finished.<\/p>\n<p>Both can be answering a reasonable question. The weekly update needs to say which question it is answering before the totals become comparable.<\/p>\n<h2>Name the event behind the date<\/h2>\n<p>Imagine a fictional repairs administrator preparing an update. A request arrived on Friday and was completed on Monday. It belongs to Friday\u2019s incoming work and Monday\u2019s completions under those definitions.<\/p>\n<p>A report about requests received last week does not automatically describe work completed last week. A view of the open queue at Friday\u2019s close is a third question again.<\/p>\n<p>Write the date rule beside each important measure. Avoid relying on one generic page title to explain several different events at once.<\/p>\n<h2>Agree the reporting boundary<\/h2>\n<p>Choose the start and end of the reporting period, including any relevant local time convention. If two systems record timestamps differently, check the intended conversion before comparing daily totals.<\/p>\n<p>You do not need an elaborate policy for a small report. You do need enough clarity that the person refreshing it and the person reading it use the same boundary.<\/p>\n<p>Use fictional records close to that boundary: a request just before the period begins, one during it and one just after it. Predict which should appear in each measure before checking the output.<\/p>\n<h2>Keep the model connected to the question<\/h2>\n<p>In Power BI, date relationships and measure design influence how a selected period applies to the data. The correct configuration depends on the structure you are building. A familiar date slicer does not, by itself, establish which business event is being filtered.<\/p>\n<p>For a small daily-channel dataset, begin by documenting exactly what the daily row represents. Do not invent case-level creation or completion dates if the source only contains daily aggregated values.<\/p>\n<p>If a new question requires information the source does not contain, identify that gap. A fresh visual cannot recover an event that was never recorded.<\/p>\n<h2>Test the wording with a reader<\/h2>\n<p>Show a colleague a measure title and ask which cases they expect it to include. Compare that answer with the actual definition. The mismatch often reveals a simpler labelling improvement than another chart would.<\/p>\n<p>Record any changed definition in the report notes so later comparisons do not silently cross two different meanings.<\/p>\n<p>The useful result is a date selection that readers can explain in ordinary language. Once the event and boundary are clear, the weekly conversation can focus on the work rather than why two reasonable people counted different things.<\/p>\n<h2>Continue with a related question<\/h2>\n<p>Explore <a href=\"https:\/\/www.kaarne.fi\/superstore\/service-dashboard-queue-definitions\/\">Keep Queue Reports Connected to the Work They Describe<\/a>, or read <a href=\"https:\/\/www.kaarne.fi\/superstore\/articles\/channel-labels-comparable\/\">You Renamed a Support Channel. Can You Still Compare Last Month?<\/a>.<\/p>\n<p>For a written practice option, see <a href=\"https:\/\/www.kaarne.fi\/superstore\/power-bi-with-matze\/\">Power BI with Matze: contents and requirements<\/a>.<\/p>\n<p><a href=\"https:\/\/einfachmitmatze.de\/power-bi-service-dashboard\/#aff=pasi5e9a&amp;cam=superstore-editorial-20261117\" rel=\"sponsored noopener\" target=\"_blank\">Review the provider\u2019s course details<\/a>. Affiliate link: Superstore may earn a commission if you buy.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Created, completed and snapshot dates answer different questions. Define the date behind each service measure before comparing channels or weeks.<\/p>\n","protected":false},"author":1,"featured_media":1689,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[35],"tags":[],"class_list":["post-1646","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ai-digital-tools"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/www.kaarne.fi\/superstore\/wp-content\/uploads\/sites\/7\/2026\/11\/power-bi-5.webp","_links":{"self":[{"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/posts\/1646","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/comments?post=1646"}],"version-history":[{"count":5,"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/posts\/1646\/revisions"}],"predecessor-version":[{"id":1828,"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/posts\/1646\/revisions\/1828"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/media\/1689"}],"wp:attachment":[{"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/media?parent=1646"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/categories?post=1646"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/tags?post=1646"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}