Commit Graph

Select branches

Hide Pull Requests

main

Mono Color

• a4a6c95cb6 Remove duplication for digital reporting main Anna Saiapina 2025-10-03 14:42:54 +0000
• 582c52957d Remove duplication for closed digital reporting Anna Saiapina 2025-10-03 14:37:09 +0000
• e42a555b8c Remove duplication for the calls report reporting Anna Saiapina 2025-10-03 13:44:19 +0000
• 0c10d61456 Remove table duplication for agent status reporting Anna Saiapina 2025-10-03 13:37:59 +0000
• b795ed49fb Delete unused stg mappings Anna Saiapina 2025-10-02 14:50:21 +0000
• 6cdfc4295e Move dataform files from export to gold folder Anna Saiapina 2025-10-02 14:27:59 +0000
• 7ed6bc8010 Replace mappings from stg to raw ones Anna Saiapina 2025-10-02 14:26:19 +0000
• ee267f4939 Change tag Anna Saiapina 2025-09-05 10:48:47 +0000
• 846c4f317b Change type Anna Saiapina 2025-09-03 12:12:42 +0000
• bbc565bcf1 Add new mapping tables Anna Saiapina 2025-09-03 12:11:12 +0000
• 2aa8a4c278 Add AFTER_CHAT_WORK to all of the digital tables Anna Saiapina 2025-02-11 10:21:59 +0000
• 28aa664250 Add AFTER_CHAT_WORK_FORMATTED field to the stg digital table Anna Saiapina 2025-02-11 10:03:12 +0000
• e17a8b87e5 Remove extra assertion Anna Saiapina 2024-12-18 11:51:45 +0000
• 6e5839a7dc Add new export Anna Saiapina 2024-12-17 15:29:36 +0000
• 70b259bf45 Add UPDATE_DESCRIPTION field for deduplication Anna Saiapina 2024-12-11 14:28:57 +0000
• b276fac1bd Add data freshness condition Anna Saiapina 2024-12-06 13:22:11 +0000
• f808d28d62 Add more alerting conditions Anna Saiapina 2024-11-25 15:53:43 +0000
• add6e94187 Change dates Anna Saiapina 2024-11-22 15:16:17 +0000
• 0c8d534db6 Export table for csc agent Anna Saiapina 2024-11-22 15:13:40 +0000
• 4928e4d508 Add columns Anna Saiapina 2024-11-21 15:42:49 +0000
• a71a9469c9 Add new mappings to csc stg table Anna Saiapina 2024-11-21 15:29:17 +0000
• 6bc54b7fd9 Change assertion column Anna Saiapina 2024-11-21 15:19:54 +0000
• 66b23b0aea Adding mappings for csc Anna Saiapina 2024-11-21 15:18:20 +0000
• 71cf8ad273 Add filter for only actual records in csc Anna Saiapina 2024-11-21 15:13:25 +0000
• 26830313de Change key columns for deduplication Anna Saiapina 2024-11-21 09:58:50 +0000
• d71b0aaa16 - Add assertion for freshness of data checking - Add filters on csc stg table Anna Saiapina 2024-11-21 09:40:07 +0000
• 3466c60434 Add ids from mappings Anna Saiapina 2024-11-20 15:58:33 +0000
• 5989584875 Add mappings in stg Anna Saiapina 2024-11-20 15:55:20 +0000
• feea18feca Add 2 new mappings as sources Anna Saiapina 2024-11-20 15:53:19 +0000
• 7a755e8ce9 Add fields to csc Anna Saiapina 2024-11-20 15:44:43 +0000
• 89d0e4549d Add mapping to the csc stg table Anna Saiapina 2024-11-20 14:48:14 +0000
• fb7769af41 csc table first look Anna Saiapina 2024-11-19 15:53:24 +0000
• be5195ab58 Add mapping MAPPING_CSC_AGENT in stg Anna Saiapina 2024-11-19 15:36:43 +0000
• 403a5ba8d3 Add new source tables Anna Saiapina 2024-11-18 16:04:34 +0000
• 94a1124b16 Add server timestamps exclude Anna Saiapina 2024-11-18 15:07:55 +0000
• 217dfad22d Update abandon_rate way of calculation Anna Saiapina 2024-11-04 08:12:37 +0000
• 2c99df472d Add export table for agent status Anna Saiapina 2024-10-11 12:26:48 +0000
• 4dfb3db0fe Add null case Anna Saiapina 2024-10-10 12:43:49 +0000
• c10a693219 Add new mapping to agent_status report tables Anna Saiapina 2024-10-10 12:27:02 +0000
• 1950c5865f Adding new mapping to raw and staging Anna Saiapina 2024-10-10 12:06:54 +0000
• 068a393ee9 Add filters for agent_status report Anna Saiapina 2024-10-10 11:58:57 +0000
• 69b4c2b851 Change June/July timestamp conversion Anna Saiapina 2024-10-10 08:38:22 +0000
• a235e0dc2b Add '' Anna Saiapina 2024-10-09 15:06:03 +0000
• 1f3de28322 +1 Anna Saiapina 2024-10-09 15:05:30 +0000
• 909529f7ed Same for history Anna Saiapina 2024-10-09 15:04:54 +0000
• 8b396f84a9 Exclude agent and reason_code from report Anna Saiapina 2024-10-09 15:04:21 +0000
• 7132055487 Exclude July from time conversion Anna Saiapina 2024-10-09 08:41:05 +0000
• 02e4d3bb0c Add timestamp change for 2023 Anna Saiapina 2024-10-08 08:28:17 +0000
• cd92aef5d0 Adding end_time to digital reports Anna Saiapina 2024-10-03 14:32:18 +0000
• 04c7706b1a Add null handling to agent table Anna Saiapina 2024-09-26 07:53:23 +0000
• 1019b3e9c9 Add one more source for agent table Anna Saiapina 2024-09-25 14:37:54 +0000
• 52d562c5c4 Update row conditions Anna Saiapina 2024-09-25 14:10:46 +0000
• b1d74d45d1 Update assertion condition Anna Saiapina 2024-09-25 13:55:39 +0000
• 8c840fa9ab Update reason code id for not mapped codes Anna Saiapina 2024-09-25 13:41:17 +0000
• 45a9d8b23c Add coalesce for ids to escape nulls Anna Saiapina 2024-09-25 13:14:39 +0000
• ddf9f1914e Chang source of the agent_name and agent_group fields Anna Saiapina 2024-09-25 08:10:20 +0000
• 2ff60831a6 Repair mistake Anna Saiapina 2024-09-24 15:08:22 +0000
• 25ef071217 Add reason code Anna Saiapina 2024-09-24 15:05:06 +0000
• 171d8d9d96 Rename Anna Saiapina 2024-09-24 15:02:12 +0000
• c70711b017 Update tables for agent status Anna Saiapina 2024-09-24 14:58:11 +0000
• 9388b345b4 New mappings to the stg layer added Anna Saiapina 2024-09-24 14:52:53 +0000
• a359728fe7 Add mappings for agent status table Anna Saiapina 2024-09-24 14:48:41 +0000
• a35eaf5428 Adding more time dimensions for agent state tables Anna Saiapina 2024-09-20 10:05:51 +0000
• 864eef441d Adding formatting for agent state time field Anna Saiapina 2024-09-20 10:01:15 +0000
• b4d42a97ac Adding date dimension to agent status related tables Anna Saiapina 2024-09-20 07:54:47 +0000
• 482dc07c5b Temporary removal of agent name not mapped condition Anna Saiapina 2024-09-19 14:21:44 +0000
• ef80c06820 Add history agent status report Anna Saiapina 2024-09-19 13:52:26 +0000
• 3a127b21cd update Anna Saiapina 2024-09-19 13:45:40 +0000
• b74ec1d161 Create report table for agent status Anna Saiapina 2024-09-19 13:42:57 +0000
• 5b5e923696 Adding mapping for agent states Anna Saiapina 2024-09-19 12:48:35 +0000
• d06636b692 Update fields for stg_agent_status table Anna Saiapina 2024-09-19 09:42:20 +0000
• 6bf5bc7037 Adding STATE field as a primary key Anna Saiapina 2024-09-18 14:40:15 +0000
• 72fd1ffba5 Pipeline for agent status data Anna Saiapina 2024-09-09 08:51:55 +0000
• 6a3dfa8a3e Update tags Anna Saiapina 2024-09-03 12:32:16 +0000
• e03bf035ed Add columns naming Anna Saiapina 2024-08-27 11:48:44 +0000
• 2dd13fdc97 Add condition to history report assertion Anna Saiapina 2024-08-27 09:59:47 +0000
• c5d3ce4a94 Update mapping joins to exclude NULL values from report tables Anna Saiapina 2024-08-27 09:55:17 +0000
• af9600e562 Adding dependencies to history report tables Anna Saiapina 2024-08-16 10:58:48 +0000
• 106247b185 Comments for tables are added Anna Saiapina 2024-08-14 09:03:34 +0000
• 67e6ffb93b Description updates Anna Saiapina 2024-08-14 08:26:38 +0000
• 44b91add66 Update assertion conditions for uniqueness Anna Saiapina 2024-07-26 14:27:16 +0000
• b7e1fce74c Update condition Anna Saiapina 2024-07-24 11:47:40 +0000
• 38dd34b87a Add dependencies from data freshness to calls and digital workflows Anna Saiapina 2024-07-24 11:29:49 +0000
• c0c600c49d Change first triggered script with the tags for calls and digital Anna Saiapina 2024-07-24 11:27:21 +0000
• 6665749ed6 Add assertion conditions for calls and digital - checking data freshness Anna Saiapina 2024-07-24 11:10:57 +0000
• 4bb7cee271 Add check for new Board properties in report Anna Saiapina 2024-07-24 09:02:33 +0000
• 75298e24d5 Change of transformation order for stg_AGENTS Anna Saiapina 2024-07-24 08:01:21 +0000
• be7bc10be4 Add new fields to digital reports Anna Saiapina 2024-07-23 11:35:38 +0000
• 5d75b24aa4 Change new fields place Anna Saiapina 2024-07-23 11:29:00 +0000
• 7700d2fb19 Add more time fields to calls reports Anna Saiapina 2024-07-23 11:26:15 +0000
• 8bc71dc2b5 Change amount of report days Anna Saiapina 2024-07-23 08:39:18 +0000
• 36e04ce745 Add board properties to digital Anna Saiapina 2024-07-22 14:57:18 +0000
• cf783bb6c5 Add board properties to calls Anna Saiapina 2024-07-22 14:08:52 +0000
• 94bbbaf09c Add mappings for board properties Anna Saiapina 2024-07-22 13:52:58 +0000
• a60be65267 1 Anna Saiapina 2024-07-19 11:41:06 +0000
• c6cfbc34d6 1 Anna Saiapina 2024-07-19 11:40:41 +0000
• cdcb432ee5 Adding disposition group to digital reports Anna Saiapina 2024-07-18 09:46:23 +0000
• b88d6e465d Add history table for digital with report fields Anna Saiapina 2024-07-17 13:55:49 +0000
• 48e5ae7399 New table for calls history in report format Anna Saiapina 2024-07-17 12:59:40 +0000
• 5f9909a7d6 Add media type to calls report Anna Saiapina 2024-07-17 12:04:18 +0000