NCR - DataCair Tickets - Revision history

Hendry.mwamburi: /* Calculations */

2026-01-30T09:21:26Z

Calculations

← Older revision		Revision as of 11:21, 30 January 2026
Line 46:		Line 46:
	\|-		\|-
	\|		\|
	# Total ~~NCR's~~		# Total Transactions Affected
	\|COALESCE(DISTINCTCOUNT('NCR_page_datacaire_tickets'[data.id]), 0)		\|COALESCE(DISTINCTCOUNT('NCR_page_datacaire_tickets'[data.id]), 0)
	\|Counts the number of unique <code>data.id</code> in NCR tickets. Returns 0 if there are no records		\|Counts the number of unique <code>data.id</code> in NCR tickets. Returns 0 if there are no records
	\|}		\|}

Hendry.mwamburi at 09:20, 30 January 2026

2026-01-30T09:20:51Z

← Older revision		Revision as of 11:20, 30 January 2026
Line 44:		Line 44:
	\|COALESCE(DISTINCTCOUNT('NCR_page_datacaire_tickets'[data.id]), 0)		\|COALESCE(DISTINCTCOUNT('NCR_page_datacaire_tickets'[data.id]), 0)
	\|Counts the number of unique <code>data.id</code> in NCR tickets. Returns 0 if there are no records		\|Counts the number of unique <code>data.id</code> in NCR tickets. Returns 0 if there are no records
			\|-
	\|		\|
	# Total NCR's		# Total NCR's

Hendry.mwamburi: /* Calculations */

2026-01-30T09:19:51Z

Calculations

← Older revision		Revision as of 11:19, 30 January 2026
Line 40:		Line 40:
	!Description		!Description
	\|-		\|-
			\|
			# Total NCR's
			\|COALESCE(DISTINCTCOUNT('NCR_page_datacaire_tickets'[data.id]), 0)
			\|Counts the number of unique <code>data.id</code> in NCR tickets. Returns 0 if there are no records
	\|		\|
	# Total NCR's		# Total NCR's

Hendry.mwamburi: /* Calculations */

2026-01-30T09:15:28Z

Calculations

← Older revision		Revision as of 11:15, 30 January 2026
Line 40:		Line 40:
	!Description		!Description
	\|-		\|-
	\|~~Example~~		\|
	\|~~Example calc~~		# Total NCR's
	\|~~Example description~~		\|COALESCE(DISTINCTCOUNT('NCR_page_datacaire_tickets'[data.id]), 0)
			\|Counts the number of unique <code>data.id</code> in NCR tickets. Returns 0 if there are no records
	\|}		\|}

Hendry.mwamburi: /* Data Transformation Applied */

2026-01-30T09:09:47Z

Data Transformation Applied

← Older revision		Revision as of 11:09, 30 January 2026
Line 31:		Line 31:

	* '''Purpose''': Retrieves comprehensive ticket information for department ID '''4''', including metadata and key lifecycle fields. The <code>limit</code> parameter is explicitly set to a very high value to ensure all relevant records are returned in a single call, bypassing default pagination limits.		* '''Purpose''': Retrieves comprehensive ticket information for department ID '''4''', including metadata and key lifecycle fields. The <code>limit</code> parameter is explicitly set to a very high value to ensure all relevant records are returned in a single call, bypassing default pagination limits.
	\|
	~~Example transformations~~
	\|}		\|}

Hendry.mwamburi: /* Data Transformation Applied */

2026-01-30T09:09:28Z

Data Transformation Applied

← Older revision		Revision as of 11:09, 30 January 2026
Line 26:		Line 26:
	!Transformations		!Transformations
	\|-		\|-
	\|~~Example Query~~		\|Datacair tickects table API link =<nowiki>https://customer-service.datacair.com/api/ticket/ticket?department=4&limit=1000000000</nowiki>
			\|
			* '''API Endpoint''': <code><nowiki>https://customer-service.datacair.com/api/ticket/ticket?department=4&limit=1000000000</nowiki></code>

			* '''Purpose''': Retrieves comprehensive ticket information for department ID '''4''', including metadata and key lifecycle fields. The <code>limit</code> parameter is explicitly set to a very high value to ensure all relevant records are returned in a single call, bypassing default pagination limits.
	\|		\|
	Example transformations		Example transformations

Hendry.mwamburi: /* Filters */

2026-01-30T09:06:59Z

Filters

← Older revision		Revision as of 11:06, 30 January 2026
Line 8:		Line 8:
	!Description		!Description
	\|-		\|-
	\|~~Example~~ filter		\|Date picker
	\|~~Filter description~~		\|Allows users to filter the dataset by a specific date or date range.
			\|-
			\|Entity slicer
			\|Enables users to filter the report by entity ( Business unit)
			\|-
			\|Region slicer
			\|Enables users to filter the report by region
			\|-

	\|}		\|}

Hendry.mwamburi: /* Summary */

2026-01-30T09:04:16Z

Summary

← Older revision		Revision as of 11:04, 30 January 2026
Line 1:		Line 1:
	== Summary ==		== Summary ==
	~~TBC~~		This Power BI report provides a centralized view of service ticket performance across entities. Its API-sourced data has calculated metrics, and user-interactive filters to enable monitoring of resolution efficiency.

	== Filters ==		== Filters ==

David.weller: Created page with "== Summary == TBC == Filters == {| class="wikitable" |+ !Filter !Description |- |Example filter |Filter description |} == Data Transformation Applied == {| class="wikitable" |+ !Query !Transformations |- |Example Query | Example transformations |} == Calculations == {| class="wikitable" |+ !Columns !Calculation !Description |- |Example |Example calc |Example description |}"

2026-01-26T13:28:47Z

Created page with "== Summary == TBC == Filters == {| class="wikitable" |+ !Filter !Description |- |Example filter |Filter description |} == Data Transformation Applied == {| class="wikitable" |+ !Query !Transformations |- |Example Query | Example transformations |} == Calculations == {| class="wikitable" |+ !Columns !Calculation !Description |- |Example |Example calc |Example description |}"

New page

== Summary ==
TBC

== Filters ==
{| class="wikitable"
|+
!Filter
!Description
|-
|Example filter
|Filter description
|}

== Data Transformation Applied ==
{| class="wikitable"
|+
!Query
!Transformations
|-
|Example Query
|
Example transformations
|}

== Calculations ==
{| class="wikitable"
|+
!Columns
!Calculation
!Description
|-
|Example
|Example calc
|Example description
|}