| DisplayName | Name | Ordinal | DisplayOption | Width | Height | PageIndex |
| Tokens per Minute | ReportSection274107f3db7e0290f899 | 3 | 1 | 1280 | 720 | 0 |
| Classification | ReportSection5b7260f06f12257e5bc1 | 4 | 1 | 1280 | 720 | 1 |
| Classification Detail | ReportSection637a8793934272634ae8 | 5 | 1 | 1280 | 720 | 2 |
| Executive Compendium | ReportSection7c37937e8779520e4d2e | 6 | 1 | 1280 | 720 | 3 |
| Users of Platform | ReportSection247b42ba5e9d28e15e36 | 9 | 1 | 1280 | 720 | 4 |
| Feedback | ReportSection94967aa013027c103e93 | 2 | 1 | 1280 | 720 | 5 |
| Summary | ReportSection86faa4adb4a7cc67119d | 1 | 1280 | 720 | 6 | |
| Chat Details | ReportSectioncbd7d951dea6b9ce35da | 7 | 1 | 1280 | 720 | 7 |
| User Details | ReportSection2812baede4592a018e41 | 8 | 1 | 1280 | 720 | 8 |
| Session Trend | ReportSection9ae288a07aa989b1b27a | 1 | 1 | 1280 | 720 | 9 |
| Visual Type | Title | X | Y | Z | Width | Height | Name | tabOrder | VisualIndex | PageIndex |
| image | 0 | 0 | 1000 | 107.15 | 60.22 | 5a2f528efbd0cb7340c3 | 0 | 0 | ||
| textbox | 1158.37 | 10.62 | 2000 | 116.9 | 38.96 | b9d39aa459bffd7fd03f | 1 | 0 | ||
| basicShape | 0 | 0 | 0 | 1280 | 59.33 | c8fa3cbae38bb24ec9d2 | 2 | 0 | ||
| lineChart | 'Total Tokens per Minute for gpt-4-32k' | 7.79 | 213.49 | 3000 | 1264.4 | 498.15 | 61bf7acd4b3e5ac8f97e | 3 | 0 | |
| slicer | 7.79 | 67.26 | 4000 | 282.71 | 84.81 | 4839f5474c381fce0e01 | 4 | 0 | ||
| tableEx | ' Tokens Capacity Per Minute ' | 325.83 | 60.3 | 5000 | 371.55 | 134.22 | 659642c67eaff1c9d8a9 | 5 | 0 | |
| tableEx | 'Max Tokens Per Minute (gpt-4-32k)' | 975.86 | 67.47 | 6000 | 289.03 | 89.63 | a154ff5d45aebb7501de | 6 | 0 |
| Visual Type | Title | X | Y | Z | Width | Height | Name | tabOrder | VisualIndex | PageIndex |
| slicer | 6.46 | 60 | 7000 | 254.78 | 80.31 | 162d5462a6cad15bdc2b | 0 | 1 | ||
| slicer | 6.71 | 59.71 | 8000 | 253.98 | 79.44 | 5e43d54567927e9672c5 | 1 | 1 | ||
| slicer | 458.59 | 59.71 | 9000 | 226.9 | 80.01 | 004bdd4234570b703bb2 | 2 | 1 | ||
| hundredPercentStackedColumnChart | 'Questions asked by Business Unit' | 5.97 | 434.7 | 10000 | 1270.68 | 283.03 | ff3df17b466e2c35648f | 3 | 1 | |
| pivotTable | 641.74 | 147.15 | 11000 | 633.56 | 284.08 | ce178f9259e91f4777be | 4 | 1 | ||
| 1074.62 | 58.74 | 6000 | 194 | 79.55 | 8caaf2d0a2053e1c10d5 | 5 | 1 | |||
| card | 'Prompt' | 2.15 | 28.07 | 14000 | 73.41 | 50.74 | c863e883119039eaf909 | 6 | 1 | |
| card | 'Response' | 105.81 | 28.09 | 15000 | 87.85 | 50.48 | 950954acb561f1226218 | 7 | 1 | |
| textbox | 'Avg Words' | 0 | 0 | 2000 | 194 | 79.55 | 05c33db33801f83b5374 | 8 | 1 | |
| textbox | 1158.37 | 10.62 | 5000 | 116.9 | 38.96 | cb3484b0d9a668e8b0a4 | 9 | 1 | ||
| card | 'Top Classification' | 719.4 | 60.29 | 1000 | 187 | 78.68 | cc3e9a0cbdd779d413ed | 10 | 1 | |
| slicer | 266.82 | 59.71 | 4000 | 186.03 | 80.78 | ad0f933bea6a0c6a8842 | 11 | 1 | ||
| shape | 0 | 0 | 0 | 1279.02 | 53.85 | 5f4f7b188231f258d0ba | 12 | 1 | ||
| image | 0 | 0 | 2000 | 102.73 | 54.9 | 1537877297f74d6aaa21 | 13 | 1 | ||
| hundredPercentStackedColumnChart | 'Questions by Classification' | 6.8 | 146.78 | 3000 | 627 | 283.84 | 6e942434460d7e76e82a | 14 | 1 |
| Visual Type | Title | X | Y | Z | Width | Height | Name | tabOrder | VisualIndex | PageIndex |
| tableEx | 11.05 | 151.71 | 1000 | 1256.89 | 558.61 | 0ad0ef2fb4932faad824 | 0 | 2 | ||
| slicer | 1049.41 | 62.68 | 2000 | 226.25 | 80.21 | e70172a2e6f647a4fd47 | 1 | 2 | ||
| slicer | 639.39 | 62.31 | 3000 | 232 | 79.64 | d28863bb986097c64b86 | 2 | 2 | ||
| slicer | 874.85 | 62.85 | 4000 | 170.14 | 80 | a6b62f48af2fac67a888 | 3 | 2 | ||
| image | 0 | 0 | 5000 | 107.15 | 60.22 | 2c2d2919ef323d2101a1 | 4 | 2 | ||
| textbox | 1158.37 | 10.62 | 6000 | 116.9 | 38.96 | be740b159113d46314a5 | 5 | 2 | ||
| basicShape | 0 | 0 | 0 | 1280 | 58.59 | b6e73fbfb6d942ebaf56 | 6 | 2 | ||
| actionButton | 0 | 0 | 7000 | 100 | 40 | 77d9c33304f78f663caf | 7 | 2 |
| Visual Type | Title | X | Y | Z | Width | Height | Name | tabOrder | VisualIndex | PageIndex |
| slicer | 6.46 | 60 | 8000 | 254.78 | 80.31 | 3a4eb5c9c1e411dee2cd | 0 | 3 | ||
| pieChart | 'Classification of Chat Questions' | 4.86 | 61.27 | 9000 | 420.18 | 351.12 | 8e790fe6407bf43689b8 | 1 | 3 | |
| lineClusteredColumnComboChart | 'Top 15 Business Units Using Ask AT&T' | 3.89 | 417.26 | 10000 | 1272.21 | 275 | 95fdc59d54131e8239fc | 2 | 3 | |
| lineChart | 'Total Questions Asked To Date' | 429.9 | 146.86 | 0 | 420.18 | 265.53 | 6cba1154ac38d3b99123 | 3 | 3 | |
| textbox | 301.51 | 693 | 1000 | 658.48 | 27 | ffc43bebfb36bee43f8c | 4 | 3 | ||
| lineClusteredColumnComboChart | 'Cumulative of Unique users and Cost' | 855.92 | 146.86 | 3000 | 420.18 | 265.53 | 207f15e7e3f381ec6914 | 5 | 3 | |
| 1069.73 | 61.37 | 7000 | 205 | 80 | 8c24dd7623a91a9a9c33 | 6 | 3 | |||
| card | 'Prompt' | 2.21 | 31.99 | 15500 | 75.25 | 47.09 | 0b63c6b1f6047a84cd78 | 7 | 3 | |
| card | 'Response' | 114.65 | 31.99 | 16000 | 89.72 | 46.68 | 2c53661619360bc424b5 | 8 | 3 | |
| textbox | 'Avg Words' | 0 | 0 | 2000 | 205 | 80 | 8e9d2e754b484c9a7927 | 9 | 3 | |
| textbox | 4.86 | 0 | 4000 | 314.16 | 54.46 | ed90e4b1b7be8b84e7d2 | 10 | 3 | ||
| 430.61 | 61.38 | 6000 | 205 | 79.75 | fae9ec616ed697d0a034 | 11 | 3 | |||
| card | 'Today' | 0.25 | 31.75 | 18000 | 80.49 | 45 | c2c26838563d6f9a53be | 12 | 3 | |
| card | 'Total' | 106.12 | 31.75 | 17500 | 93.37 | 45 | 5726e68a1c599b065c2f | 13 | 3 | |
| textbox | 0 | 0 | 0 | 205 | 79.75 | 7ac499eccf86e4e63d63 | 14 | 3 | ||
| 643.65 | 60.03 | 5000 | 205 | 80 | 3da225007cd627765cd0 | 15 | 3 | |||
| card | 'Today' | 2.38 | 33.1 | 3000 | 87.85 | 45.71 | 3b09c42335a0d3380101 | 16 | 3 | |
| card | 'Total ' | 109.84 | 33.1 | 2500 | 91.33 | 45 | a6952c8c4b01dfc1aea4 | 17 | 3 | |
| textbox | 0 | 0 | 0 | 205 | 80 | 731361565b1308a102d8 | 18 | 3 | ||
| card | 'Unique ' | 861.23 | 93.13 | 12000 | 93.13 | 44.77 | 962b11b6ca2c13f9715e | 19 | 3 | |
| card | 'Cost per' | 960.71 | 93.13 | 11000 | 99.2 | 45 | 09cbad5310bf5d80eb4c | 20 | 3 | |
| textbox | 856.69 | 61.13 | 2000 | 205 | 80 | a6b42c6c8f0d95fb3d87 | 21 | 3 |
| Visual Type | Title | X | Y | Z | Width | Height | Name | tabOrder | VisualIndex | PageIndex |
| tableEx | 9.64 | 0 | 0 | 1270.55 | 720.11 | e27e9698baccd1375e04 | 0 | 4 |
| Visual Type | Title | X | Y | Z | Width | Height | Name | tabOrder | VisualIndex | PageIndex |
| slicer | 82.07 | 60 | 9000 | 164.15 | 43.96 | 8364f36392f1bec1aa4d | 0 | 5 | ||
| textbox | 21.49 | 70 | 1000 | 60.58 | 25.4 | 20ace57c169b2b5361c8 | 1 | 5 | ||
| slicer | 6.46 | 60 | 11000 | 254.78 | 80.31 | 297f8da303fc91521346 | 2 | 5 | ||
| lineChart | '% positive (yes/Total feedback) by Month and Day' | 646.83 | 460.21 | 3000 | 624.36 | 254.04 | 9ad17358cc6115136d47 | 3 | 5 | |
| lineChart | 7.81 | 460.21 | 4000 | 630.22 | 254.04 | 00400237c260d90b8570 | 4 | 5 | ||
| lineChart | 645.86 | 104.54 | 5000 | 625.34 | 349.8 | 50e7ea8c423b970009b5 | 5 | 5 | ||
| pivotTable | 7.81 | 104.54 | 6000 | 630.22 | 349.8 | d636b6957d06801ae6c0 | 6 | 5 | ||
| image | 0 | 0 | 7000 | 107.15 | 60.22 | d01a5fe8ecaad17e811c | 7 | 5 | ||
| textbox | 1031.34 | 10.92 | 8000 | 243.63 | 38.23 | 80d6203700d136704cd3 | 8 | 5 | ||
| basicShape | 0 | 0 | 2000 | 1280.44 | 58.69 | 1c1f503f3eb0ab8b4eda | 9 | 5 |
| Visual Type | Title | X | Y | Z | Width | Height | Name | tabOrder | VisualIndex | PageIndex |
| slicer | 3.41 | 60.3 | 19000 | 232.1 | 79.64 | e327cce0881c41b45145 | 0 | 6 | ||
| slicer | 238.93 | 60.3 | 0 | 169.52 | 80 | 217ba84b003f9c4c68d4 | 1 | 6 | ||
| card | 522.24 | 65.03 | 15000 | 109.22 | 71.68 | 692e96a40da5bb000507 | 2 | 6 | ||
| multiRowCard | 'GPT Token Costs' | 865.97 | 144 | 16000 | 410.14 | 265 | 9d3d308a9dd5aed5a618 | 3 | 6 | |
| card | 'Today' | 1186.61 | 84.27 | 3000 | 86.54 | 48.96 | 5d9708f7861540531e88 | 4 | 6 | |
| card | '# of New PVAs This Month' | 1028 | 84.19 | 5000 | 90 | 48.92 | 4d3d79b2860720ae7400 | 5 | 6 | |
| textbox | 'Today''s Tokens' | 1121 | 65.03 | 2000 | 153.6 | 71.68 | 8b8fe45ba35b05a2e8ea | 6 | 6 | |
| textbox | 'Tokens' | 948 | 65.03 | 1000 | 170.66 | 71.68 | 628c43ee00ae5b6032e2 | 7 | 6 | |
| clusteredColumnChart | 'Token Cost by Business Unit' | 5.68 | 413.01 | 18000 | 1270.89 | 301.51 | 6a39b206ac6e6c55c09e | 8 | 6 | |
| card | '# of New PVAs This Month' | 948.9 | 84.19 | 14000 | 79.64 | 48.92 | 45a894ec780adbcc94be | 9 | 6 | |
| basicShape | 0 | 0 | 4000 | 1280 | 58.85 | 977496a9848179b892dc | 10 | 6 | ||
| image | 0 | 0 | 6000 | 107.15 | 60.22 | b5df95ced975cbbd0a50 | 11 | 6 | ||
| textbox | 1158.37 | 10.62 | 7000 | 116.9 | 38.96 | 8750f825a241be05babd | 12 | 6 | ||
| card | 633.74 | 65.03 | 8000 | 174.08 | 71.68 | f8dbed6fd468b3070382 | 13 | 6 | ||
| card | 810.09 | 65.03 | 11000 | 136.53 | 71.68 | 59703309bc2c681c7172 | 14 | 6 | ||
| card | 412 | 64.85 | 9000 | 109 | 71.68 | a4894bbd4ea252215363 | 15 | 6 | ||
| pieChart | '# of Users By Chat Model' | 5.68 | 144.49 | 10000 | 424.39 | 265.1 | a942dacdd16b8a80b680 | 16 | 6 | |
| pieChart | 'Classification of Chat Requests' | 436.9 | 144.49 | 12000 | 424.39 | 265.1 | 831bd63edb46624b2684 | 17 | 6 | |
| card | 'Today' | 1121.84 | 85.33 | 13000 | 72.81 | 48.92 | 938ce2cec36d7e69b33a | 18 | 6 |
| Visual Type | Title | X | Y | Z | Width | Height | Name | tabOrder | VisualIndex | PageIndex |
| slicer | 1023.79 | 61.28 | 6000 | 249.16 | 55.25 | f39520405757af15eec5 | 0 | 7 | ||
| slicer | 6.46 | 60 | 5000 | 254.78 | 80.31 | 253ded6d447eff6e2c77 | 1 | 7 | ||
| textbox | 1158.37 | 10.62 | 4000 | 116.9 | 38.96 | 7ceb27b55ee72515c030 | 2 | 7 | ||
| tableEx | 11.05 | 121.56 | 1000 | 1261.91 | 591.77 | 0e639eb9f2d50ba1d88a | 3 | 7 | ||
| image | 0 | 0 | 2000 | 97.34 | 54.37 | 3d612c9e3aefd8493b6a | 4 | 7 | ||
| shape | 0 | 0.89 | 0 | 1279.1 | 53.85 | 34325b6ec21351339bb9 | 5 | 7 | ||
| actionButton | 0 | 54.44 | 3000 | 136.1 | 40.32 | 39693630639002a87cec | 6 | 7 |
| Visual Type | Title | X | Y | Z | Width | Height | Name | tabOrder | VisualIndex | PageIndex |
| slicer | 6.46 | 60 | 5000 | 254.78 | 80.31 | ad589db65daa869c0a93 | 0 | 8 | ||
| textbox | 1158.37 | 10.62 | 4000 | 116.9 | 38.96 | 55c5e9862e6226a04d1b | 1 | 8 | ||
| pivotTable | 8.06 | 111.9 | 1000 | 1264.27 | 601.89 | 2100b138c76bde47bd79 | 2 | 8 | ||
| actionButton | 0 | 55.45 | 2000 | 135.09 | 49.4 | 857e58b24c628e793af4 | 3 | 8 | ||
| image | 0 | 0 | 3000 | 100.95 | 54.02 | 65c149bb3593411390c0 | 4 | 8 | ||
| shape | 0 | 0.89 | 0 | 1279.1 | 53.85 | 821c148129b0568a7710 | 5 | 8 |
| Visual Type | Title | X | Y | Z | Width | Height | Name | tabOrder | VisualIndex | PageIndex |
| slicer | 6.46 | 60 | 14000 | 254.78 | 80.31 | 75f6cb939f7c3f100d6c | 0 | 9 | ||
| slicer | 6.71 | 61.53 | 15000 | 253.98 | 79.44 | ffe77c1cdda4a5e4b42b | 1 | 9 | ||
| lineChart | 'Cumulative of Unique users' | 638.64 | 146.78 | 8000 | 631.83 | 282.86 | c3bdb4a72c6204512215 | 2 | 9 | |
| lineClusteredColumnComboChart | 'Top 15 Business Units Using Ask AT&T' | 638.64 | 433.53 | 9000 | 633.78 | 282.86 | 8218bf48c996a72190a5 | 3 | 9 | |
| 1074.62 | 58.74 | 13000 | 194 | 79.55 | 4d97037a453c95610e67 | 4 | 9 | |||
| card | 'Prompt' | 2.15 | 28.07 | 14000 | 73.41 | 50.74 | 10bfc7831c559e738a52 | 5 | 9 | |
| card | 'Response' | 105.81 | 28.09 | 15000 | 87.85 | 50.48 | 917f9577e9947a678cde | 6 | 9 | |
| textbox | 'Avg Words' | 0 | 0 | 2000 | 194 | 79.55 | d3b706f67c20560e0035 | 7 | 9 | |
| textbox | 1158.37 | 10.62 | 10000 | 116.9 | 38.96 | c321d98ac2de2182e53d | 8 | 9 | ||
| 460.2 | 61.19 | 12000 | 190 | 78.33 | 5c361bb64c7cd15e7a0b | 9 | 9 | |||
| card | 'Today' | 0 | 25.7 | 17000 | 62.42 | 52.62 | e2d5cd37aa795d88a54c | 10 | 9 | |
| card | 'Total' | 96.69 | 26.92 | 12000 | 72.21 | 51.4 | caf40630d20a07d6523c | 11 | 9 | |
| textbox | 0 | 0 | 0 | 190 | 78.33 | 0e4af094cd35ec684c89 | 12 | 9 | ||
| 665.01 | 61.19 | 11000 | 190 | 78.33 | e9dbb05071a0863277e0 | 13 | 9 | |||
| card | 'Today' | 0 | 25.46 | 2000 | 72.16 | 51.4 | 28e3a254e438c947910d | 14 | 9 | |
| card | 'Total ' | 92.21 | 23.25 | 1000 | 94.88 | 52.62 | c92c67d9d864a3523b65 | 15 | 9 | |
| textbox | 0.22 | 0 | 0 | 189.77 | 78.33 | 4c8fe1583886be1482aa | 16 | 9 | ||
| card | 'Unique ' | 872.67 | 85.67 | 3000 | 93.01 | 52.62 | d533733edb2eb94a2886 | 17 | 9 | |
| card | 'Cost per' | 958.35 | 85.67 | 1000 | 99.13 | 52.62 | 77c92deed0ed1601c90c | 18 | 9 | |
| textbox | 869.81 | 59.97 | 0 | 190 | 78.33 | 6e276753dc0d2541e370 | 19 | 9 | ||
| slicer | 266.82 | 59.97 | 7000 | 186.03 | 80.78 | 29275eeba80569e4b2c8 | 20 | 9 | ||
| shape | 0 | 0 | 2000 | 1279.02 | 53.85 | c75cde2b1d17488522cc | 21 | 9 | ||
| image | 0 | 0 | 4000 | 102.73 | 54.9 | adf612e6a00e48cb89e0 | 22 | 9 | ||
| lineChart | 'Total Questions To Date' | 6.8 | 146.78 | 5000 | 627 | 283.84 | 4a2cbddfda3a81e22c0e | 23 | 9 | |
| lineChart | 'Cumulative Token Cost Over Time' | 6.8 | 433.53 | 6000 | 626.97 | 282.86 | 10b2022b1725910e89b0 | 24 | 9 |
| DisplayName | Page Name | Index | Name |
| KeyPhrases open | ReportSectiona1f2c542080ed8937c0a | 0 | Bookmarka315b102158e527aa348 |
| Key Phrases Closed | ReportSectiona1f2c542080ed8937c0a | 1 | Bookmark5ee8fad27a100ed041a2 |
| Name | Table Name | Aggregation | Expression | VisualIndex | PageIndex |
| Createdon(CST) | pvarpa_asklillyandalex | pvarpa_asklillyandalex.Createdon(CST) (Minute) | 3 | 0 | |
| total_tokens | pvarpa_asklillyandalex | Sum | Sum(pvarpa_asklillyandalex.total_tokens) | 3 | 0 |
| dateDisplay | Date 2 | Date 2.dateDisplay | 4 | 0 | |
| Model | Capacity | Capacity.Model | 5 | 0 | |
| TPM | Capacity | Capacity.TPM (Shows in Quotas) | 5 | 0 | |
| Createdon(CST) | pvarpa_asklillyandalex | pvarpa_asklillyandalex.Createdon(CST) (Minute) | 6 | 0 | |
| total_tokens | pvarpa_asklillyandalex | Sum | Sum(pvarpa_asklillyandalex.total_tokens) | 6 | 0 |
| Date | Date 2 | Date 2.Date | 0 | 1 | |
| Date | Date 2 | Date 2.Date | 1 | 1 | |
| ClassificationWithCoding | pvarpa_asklillyandalex | pvarpa_asklillyandalex.ClassificationWithCoding | 2 | 1 | |
| CodeSubClassification | pvarpa_asklillyandalex | pvarpa_asklillyandalex.CodeSubClassification | 2 | 1 | |
| BusinessUnitName | vwWPUserBusinessUnit | vwWPUserBusinessUnit.BusinessUnitName | 3 | 1 | |
| Full Name | vwWPUserBusinessUnit | vwWPUserBusinessUnit.Full Name | 3 | 1 | |
| 0000 Ask Lilly and Alex | pvarpa_asklillyandalex | CountNonNull | CountNonNull(pvarpa_asklillyandalex.0000 Ask Lilly and Alex) | 3 | 1 |
| ClassificationWithCoding | pvarpa_asklillyandalex | pvarpa_asklillyandalex.ClassificationWithCoding | 3 | 1 | |
| A measure_Keeper | A measure_Keeper.% ATT & Coding | 3 | 1 | ||
| BusinessUnitName | vwWPUserBusinessUnit | vwWPUserBusinessUnit.BusinessUnitName | 4 | 1 | |
| ClassificationWithCoding | pvarpa_asklillyandalex | pvarpa_asklillyandalex.ClassificationWithCoding | 4 | 1 | |
| ClassificationWithCoding | pvarpa_asklillyandalex | Min | Min(pvarpa_asklillyandalex.ClassificationWithCoding) | 4 | 1 |
| Avg prompt word | A measure_Keeper | A measure_Keeper.Avg prompt word | 6 | 1 | |
| Avg words Response | A measure_Keeper | A measure_Keeper.Avg words Response | 7 | 1 | |
| ClassificationWithCoding | pvarpa_asklillyandalex | Min | Min(pvarpa_asklillyandalex.ClassificationWithCoding) | 10 | 1 |
| model | pvarpa_asklillyandalex | pvarpa_asklillyandalex.model | 11 | 1 | |
| Year | Date 2.dateDisplay.Variation.Date Hierarchy.Year | 14 | 1 | ||
| Month | Date 2.dateDisplay.Variation.Date Hierarchy.Month | 14 | 1 | ||
| Day | Date 2.dateDisplay.Variation.Date Hierarchy.Day | 14 | 1 | ||
| ClassificationWithCoding | pvarpa_asklillyandalex | pvarpa_asklillyandalex.ClassificationWithCoding | 14 | 1 | |
| ClassificationWithCoding | pvarpa_asklillyandalex | CountNonNull | CountNonNull(pvarpa_asklillyandalex.ClassificationWithCoding) | 14 | 1 |
| ClassificationWithCoding | pvarpa_asklillyandalex | pvarpa_asklillyandalex.ClassificationWithCoding | 14 | 1 | |
| CreatedOnDate(CST) | pvarpa_asklillyandalex | pvarpa_asklillyandalex.CreatedOnDate(CST) | 0 | 2 | |
| PVA chatbot | pvarpa_asklillyandalex | pvarpa_asklillyandalex.PVA chatbot | 0 | 2 | |
| ClassificationWithCoding | pvarpa_asklillyandalex | pvarpa_asklillyandalex.ClassificationWithCoding | 0 | 2 | |
| CodeSubClassification | pvarpa_asklillyandalex | pvarpa_asklillyandalex.CodeSubClassification | 0 | 2 | |
| model | pvarpa_asklillyandalex | pvarpa_asklillyandalex.model | 0 | 2 | |
| prompt | pvarpa_asklillyandalex | pvarpa_asklillyandalex.prompt/request | 0 | 2 | |
| text | pvarpa_asklillyandalex | pvarpa_asklillyandalex.text/response | 0 | 2 | |
| ClassificationWithCoding | pvarpa_asklillyandalex | pvarpa_asklillyandalex.ClassificationWithCoding | 1 | 2 | |
| CodeSubClassification | pvarpa_asklillyandalex | pvarpa_asklillyandalex.CodeSubClassification | 1 | 2 | |
| Date | Date 2 | Date 2.Date | 2 | 2 | |
| model | pvarpa_asklillyandalex | pvarpa_asklillyandalex.model | 3 | 2 | |
| Date | Date 2 | Date 2.Date | 0 | 3 | |
| 0000 Ask Lilly and Alex | pvarpa_asklillyandalex | CountNonNull | CountNonNull(pvarpa_asklillyandalex.0000 Ask Lilly and Alex) | 1 | 3 |
| ClassifiedTop4 | pvarpa_asklillyandalex | pvarpa_asklillyandalex.ClassifiedTop4 | 1 | 3 | |
| BusinessUnitName | vwWPUserBusinessUnit | vwWPUserBusinessUnit.BusinessUnitName | 2 | 3 | |
| Full Name | vwWPUserBusinessUnit | vwWPUserBusinessUnit.Full Name | 2 | 3 | |
| userID | pvarpa_asklillyandalex | CountNonNull | CountNonNull(pvarpa_asklillyandalex.userID) | 2 | 3 |
| Created On | pvarpa_asklillyandalex | CountNonNull | CountNonNull(pvarpa_asklillyandalex.Created On) | 2 | 3 |
| Month | Date 2.dateDisplay.Variation.Date Hierarchy.Month | 3 | 3 | ||
| cummulative of questions | A measure_Keeper | A measure_Keeper.cummulative of questions | 3 | 3 | |
| Lastcumumulative Question | A measure_Keeper | A measure_Keeper.Lastcumumulative Question | 3 | 3 | |
| Month | Date 2.dateDisplay.Variation.Date Hierarchy.Month | 5 | 3 | ||
| Cummulative of users | A measure_Keeper | A measure_Keeper.Cummulative of users | 5 | 3 | |
| Cummulative of cost | A measure_Keeper | A measure_Keeper.Cummulative of cost | 5 | 3 | |
| Lastest Cumumulative Cost | A measure_Keeper | A measure_Keeper.Lastest Cumumulative Cost | 5 | 3 | |
| Avg prompt word | A measure_Keeper | A measure_Keeper.Avg prompt word | 7 | 3 | |
| Avg words Response | A measure_Keeper | A measure_Keeper.Avg words Response | 8 | 3 | |
| A measure_Keeper | A measure_Keeper.# of questions | 12 | 3 | ||
| Created On | pvarpa_asklillyandalex | Min | Min(pvarpa_asklillyandalex.Created On) | 13 | 3 |
| Cost | A measure_Keeper | A measure_Keeper.Cost | 16 | 3 | |
| Cost | pvarpa_asklillyandalex | Sum | Sum(pvarpa_asklillyandalex.Cost) | 17 | 3 |
| userID | pvarpa_asklillyandalex | Min | Min(pvarpa_asklillyandalex.userID) | 19 | 3 |
| Cost per User | A measure_Keeper | A measure_Keeper.Cost per User | 20 | 3 | |
| ATTUID | pvarpa_asklillyandalex | pvarpa_asklillyandalex.ATTUID | 0 | 4 | |
| Full Name | vwWPUserBusinessUnit | vwWPUserBusinessUnit.Full Name | 0 | 4 | |
| BusinessUnitName | vwWPUserBusinessUnit | vwWPUserBusinessUnit.BusinessUnitName | 0 | 4 | |
| ConsultantFlag | vwWPUserBusinessUnit | vwWPUserBusinessUnit.ConsultantFlag | 0 | 4 | |
| createdon _Date | pvarpa_asklillyandalex | pvarpa_asklillyandalex.createdon _Date | 0 | 4 | |
| CountryDesc | vwWPUserBusinessUnit | vwWPUserBusinessUnit.CountryDesc | 0 | 4 | |
| State | vwWPUserBusinessUnit | vwWPUserBusinessUnit.State | 0 | 4 | |
| City | vwWPUserBusinessUnit | vwWPUserBusinessUnit.City | 0 | 4 | |
| model | pvarpa_asklillyandalex | pvarpa_asklillyandalex.model | 0 | 5 | |
| Date | Date 2 | Date 2.Date | 2 | 5 | |
| Month | Date 2.dateDisplay.Variation.Date Hierarchy.Month | 3 | 5 | ||
| Day | Date 2.dateDisplay.Variation.Date Hierarchy.Day | 3 | 5 | ||
| A measure_Keeper | A measure_Keeper.% positive(yes/Tot feedback | 3 | 5 | ||
| A measure_Keeper | A measure_Keeper.% Feedback Received | 4 | 5 | ||
| Month | Date 2.dateDisplay.Variation.Date Hierarchy.Month | 4 | 5 | ||
| Day | Date 2.dateDisplay.Variation.Date Hierarchy.Day | 4 | 5 | ||
| Month | Date 2.dateDisplay.Variation.Date Hierarchy.Month | 5 | 5 | ||
| Day | Date 2.dateDisplay.Variation.Date Hierarchy.Day | 5 | 5 | ||
| A measure_Keeper | A measure_Keeper.# of questions | 5 | 5 | ||
| A measure_Keeper | A measure_Keeper.% 'I don't Know' | 5 | 5 | ||
| A measure_Keeper | A measure_Keeper.# of questions | 6 | 5 | ||
| Total feedback | A measure_Keeper | A measure_Keeper.Total feedback | 6 | 5 | |
| A measure_Keeper | A measure_Keeper.% Feedback Received | 6 | 5 | ||
| Positive Feedback | A measure_Keeper | A measure_Keeper.Positive Feedback | 6 | 5 | |
| A measure_Keeper | A measure_Keeper.% positive(yes/Tot feedback | 6 | 5 | ||
| IDK Response | pvarpa_asklillyandalex | Sum | Sum(pvarpa_asklillyandalex.IDK Response) | 6 | 5 |
| CreatedOnDate(CST) | pvarpa_asklillyandalex | pvarpa_asklillyandalex.CreatedOnDate(CST) | 6 | 5 | |
| Date | Date 2 | Date 2.Date | 0 | 6 | |
| Date | Date 2 | Date 2.Date | 0 | 6 | |
| model | pvarpa_asklillyandalex | pvarpa_asklillyandalex.model | 1 | 6 | |
| model | pvarpa_asklillyandalex | pvarpa_asklillyandalex.model | 1 | 6 | |
| Count of users | A measure_Keeper | A measure_Keeper.Count of users | 2 | 6 | |
| model | pvarpa_asklillyandalex | pvarpa_asklillyandalex.model | 3 | 6 | |
| MTD | A measure_Keeper | A measure_Keeper.MTD (total Tokens) | 3 | 6 | |
| QTD_TotalTokens | A measure_Keeper | A measure_Keeper.QTD_TotalTokens | 3 | 6 | |
| YTD | A measure_Keeper | A measure_Keeper.YTD(Total Tokens) | 3 | 6 | |
| Cost | A measure_Keeper | A measure_Keeper.Cost | 4 | 6 | |
| YTD | A measure_Keeper | A measure_Keeper.YTD(Total Tokens) | 5 | 6 | |
| BusinessUnitName | vwWPUserBusinessUnit | vwWPUserBusinessUnit.BusinessUnitName | 8 | 6 | |
| Full Name | vwWPUserBusinessUnit | vwWPUserBusinessUnit.Full Name | 8 | 6 | |
| C_TokenCost | pvarpa_asklillyandalex | Sum | Sum(pvarpa_asklillyandalex.C_TokenCost) | 8 | 6 |
| BusinessUnitName | vwWPUserBusinessUnit | vwWPUserBusinessUnit.BusinessUnitName | 8 | 6 | |
| Total Tokens used | A measure_Keeper | A measure_Keeper.Total Tokens used | 9 | 6 | |
| Created On | pvarpa_asklillyandalex | Min | Min(pvarpa_asklillyandalex.Created On) | 13 | 6 |
| A measure_Keeper | A measure_Keeper.# of Launches | 14 | 6 | ||
| cummulative of questions | A measure_Keeper | A measure_Keeper.cummulative of questions | 15 | 6 | |
| pvarpa_userid | pvarpa_asklillyandalex | Count | Count(pvarpa_asklillyandalex.pvarpa_userid) | 16 | 6 |
| model | pvarpa_asklillyandalex | pvarpa_asklillyandalex.model | 16 | 6 | |
| model | pvarpa_asklillyandalex | pvarpa_asklillyandalex.model | 16 | 6 | |
| 0000 Ask Lilly and Alex | pvarpa_asklillyandalex | CountNonNull | CountNonNull(pvarpa_asklillyandalex.0000 Ask Lilly and Alex) | 17 | 6 |
| ClassifiedTop4 | pvarpa_asklillyandalex | pvarpa_asklillyandalex.ClassifiedTop4 | 17 | 6 | |
| ClassifiedTop4 | pvarpa_asklillyandalex | pvarpa_asklillyandalex.ClassifiedTop4 | 17 | 6 | |
| Total Tokens used | A measure_Keeper | A measure_Keeper.Total Tokens used | 18 | 6 | |
| model | pvarpa_asklillyandalex | pvarpa_asklillyandalex.model | 0 | 7 | |
| model | pvarpa_asklillyandalex | pvarpa_asklillyandalex.model | 0 | 7 | |
| Date | Date 2 | Date 2.Date | 1 | 7 | |
| Createdon(CST) | pvarpa_asklillyandalex | pvarpa_asklillyandalex.Createdon(CST) | 3 | 7 | |
| Name | pvarpa_asklillyandalex | pvarpa_asklillyandalex.Name | 3 | 7 | |
| model | pvarpa_asklillyandalex | pvarpa_asklillyandalex.model | 3 | 7 | |
| prompt_tokens | pvarpa_asklillyandalex | Sum | Sum(pvarpa_asklillyandalex.prompt_tokens) | 3 | 7 |
| completion_tokens | pvarpa_asklillyandalex | Sum | Sum(pvarpa_asklillyandalex.completion_tokens) | 3 | 7 |
| total_tokens | pvarpa_asklillyandalex | Sum | Sum(pvarpa_asklillyandalex.total_tokens) | 3 | 7 |
| prompt | pvarpa_asklillyandalex | pvarpa_asklillyandalex.prompt | 3 | 7 | |
| text | pvarpa_asklillyandalex | pvarpa_asklillyandalex.text/response | 3 | 7 | |
| ATTUID | pvarpa_asklillyandalex | pvarpa_asklillyandalex.ATTUID | 3 | 7 | |
| Chat_Feedback | pvarpa_asklillyandalex | pvarpa_asklillyandalex.Chat_Feedback | 3 | 7 | |
| Chat_Feedback_Comments | pvarpa_asklillyandalex | pvarpa_asklillyandalex.Chat_Feedback_Comments | 3 | 7 | |
| Date | Date 2 | Date 2.Date | 0 | 8 | |
| Name | pvarpa_asklillyandalex | pvarpa_asklillyandalex.Name | 2 | 8 | |
| BusinessUnitName | vwWPUserBusinessUnit | vwWPUserBusinessUnit.BusinessUnitName | 2 | 8 | |
| Full Name | vwWPUserBusinessUnit | vwWPUserBusinessUnit.Full Name | 2 | 8 | |
| prompt_tokens | pvarpa_asklillyandalex | Sum | Sum(pvarpa_asklillyandalex.prompt_tokens) | 2 | 8 |
| completion_tokens | pvarpa_asklillyandalex | Sum | Sum(pvarpa_asklillyandalex.completion_tokens) | 2 | 8 |
| total_tokens | pvarpa_asklillyandalex | Sum | Sum(pvarpa_asklillyandalex.total_tokens) | 2 | 8 |
| Cost | pvarpa_asklillyandalex | Sum | Sum(pvarpa_asklillyandalex.Cost) | 2 | 8 |
| Name | pvarpa_asklillyandalex | pvarpa_asklillyandalex.Name | 2 | 8 | |
| BusinessUnitName | vwWPUserBusinessUnit | vwWPUserBusinessUnit.BusinessUnitName | 2 | 8 | |
| Full Name | vwWPUserBusinessUnit | vwWPUserBusinessUnit.Full Name | 2 | 8 | |
| Date | Date 2 | Date 2.Date | 0 | 9 | |
| Date | Date 2 | Date 2.Date | 1 | 9 | |
| Date | Date 2 | Date 2.Date | 1 | 9 | |
| Year | Date 2.dateDisplay.Variation.Date Hierarchy.Year | 2 | 9 | ||
| Month | Date 2.dateDisplay.Variation.Date Hierarchy.Month | 2 | 9 | ||
| Day | Date 2.dateDisplay.Variation.Date Hierarchy.Day | 2 | 9 | ||
| Cummulative of users | A measure_Keeper | A measure_Keeper.Cummulative of users | 2 | 9 | |
| Lastcumumulative user | A measure_Keeper | A measure_Keeper.Lastcumumulative user | 2 | 9 | |
| Year | Date 2.dateDisplay.Variation.Date Hierarchy.Year | 2 | 9 | ||
| Month | Date 2.dateDisplay.Variation.Date Hierarchy.Month | 2 | 9 | ||
| BusinessUnitName | vwWPUserBusinessUnit | vwWPUserBusinessUnit.BusinessUnitName | 3 | 9 | |
| Full Name | vwWPUserBusinessUnit | vwWPUserBusinessUnit.Full Name | 3 | 9 | |
| userID | pvarpa_asklillyandalex | CountNonNull | CountNonNull(pvarpa_asklillyandalex.userID) | 3 | 9 |
| Created On | pvarpa_asklillyandalex | CountNonNull | CountNonNull(pvarpa_asklillyandalex.Created On) | 3 | 9 |
| BusinessUnitName | vwWPUserBusinessUnit | vwWPUserBusinessUnit.BusinessUnitName | 3 | 9 | |
| Avg prompt word | A measure_Keeper | A measure_Keeper.Avg prompt word | 5 | 9 | |
| Avg words Response | A measure_Keeper | A measure_Keeper.Avg words Response | 6 | 9 | |
| A measure_Keeper | A measure_Keeper.# of questions | 10 | 9 | ||
| Created On | pvarpa_asklillyandalex | Min | Min(pvarpa_asklillyandalex.Created On) | 11 | 9 |
| Cost | A measure_Keeper | A measure_Keeper.Cost | 14 | 9 | |
| Cost | pvarpa_asklillyandalex | Sum | Sum(pvarpa_asklillyandalex.Cost) | 15 | 9 |
| userID | pvarpa_asklillyandalex | Min | Min(pvarpa_asklillyandalex.userID) | 17 | 9 |
| Cost per User | A measure_Keeper | A measure_Keeper.Cost per User | 18 | 9 | |
| model | pvarpa_asklillyandalex | pvarpa_asklillyandalex.model | 20 | 9 | |
| model | pvarpa_asklillyandalex | pvarpa_asklillyandalex.model | 20 | 9 | |
| Year | Date 2.dateDisplay.Variation.Date Hierarchy.Year | 23 | 9 | ||
| Month | Date 2.dateDisplay.Variation.Date Hierarchy.Month | 23 | 9 | ||
| Day | Date 2.dateDisplay.Variation.Date Hierarchy.Day | 23 | 9 | ||
| cummulative of questions | A measure_Keeper | A measure_Keeper.cummulative of questions | 23 | 9 | |
| Lastcumumulative Question | A measure_Keeper | A measure_Keeper.Lastcumumulative Question | 23 | 9 | |
| Year | Date 2.dateDisplay.Variation.Date Hierarchy.Year | 23 | 9 | ||
| Month | Date 2.dateDisplay.Variation.Date Hierarchy.Month | 23 | 9 | ||
| Year | Date 2.dateDisplay.Variation.Date Hierarchy.Year | 24 | 9 | ||
| Month | Date 2.dateDisplay.Variation.Date Hierarchy.Month | 24 | 9 | ||
| Day | Date 2.dateDisplay.Variation.Date Hierarchy.Day | 24 | 9 | ||
| Cummulative of cost | A measure_Keeper | A measure_Keeper.Cummulative of cost | 24 | 9 | |
| Lastest Cumumulative Cost | A measure_Keeper | A measure_Keeper.Lastest Cumumulative Cost | 24 | 9 | |
| Year | Date 2.dateDisplay.Variation.Date Hierarchy.Year | 24 | 9 | ||
| Month | Date 2.dateDisplay.Variation.Date Hierarchy.Month | 24 | 9 |
| Name |
| pvarpa_asklillyandalex |
| Date 2 |
| Capacity |
| vwWPUserBusinessUnit |
| A measure_Keeper |
| Name | Table Name | State | Data Category | Data Type | Description | Display Folder | Error Message | Format String | Is Hidden | Modified Time | Structure Modified Time | Sort by Column | Summarize By | Type | Expression |
| prompt/request | pvarpa_asklillyandalex | COLUMN | |||||||||||||
| text/response | pvarpa_asklillyandalex | COLUMN | |||||||||||||
| pvarpa_pvachatbot | pvarpa_asklillyandalex | COLUMN | |||||||||||||
| Botid | pvarpa_asklillyandalex | COLUMN | |||||||||||||
| UserFullName | pvarpa_asklillyandalex | COLUMN | |||||||||||||
| Level4up | pvarpa_asklillyandalex | COLUMN | |||||||||||||
| Promptwordcount | pvarpa_asklillyandalex | COLUMN | |||||||||||||
| Wordcountof anwers | pvarpa_asklillyandalex | COLUMN | |||||||||||||
| StartTime | pvarpa_asklillyandalex | COLUMN | |||||||||||||
| EndTime | pvarpa_asklillyandalex | COLUMN | |||||||||||||
| StartTime (CT) | pvarpa_asklillyandalex | COLUMN | |||||||||||||
| Comment_Present | pvarpa_asklillyandalex | COLUMN | |||||||||||||
| Feedback Date(CST) | pvarpa_asklillyandalex | COLUMN | |||||||||||||
| Classification | pvarpa_asklillyandalex | COLUMN | |||||||||||||
| CreatedOnHour | pvarpa_asklillyandalex | COLUMN | |||||||||||||
| Created On (Min) | pvarpa_asklillyandalex | COLUMN | |||||||||||||
| RecordsPerMinute | pvarpa_asklillyandalex | COLUMN | |||||||||||||
| Created On (hr) | pvarpa_asklillyandalex | COLUMN | |||||||||||||
| createdon - Time | pvarpa_asklillyandalex | COLUMN | |||||||||||||
| CodeScan | pvarpa_asklillyandalex | COLUMN | |||||||||||||
| SubClassification | pvarpa_asklillyandalex | COLUMN | |||||||||||||
| Createdon(CST) (Minute) | pvarpa_asklillyandalex | COLUMN | |||||||||||||
| Date | Date | COLUMN | |||||||||||||
| dateDisplay | Date | COLUMN | |||||||||||||
| Today | Date 2 | COLUMN | |||||||||||||
| ATTUID | vwWPUserBusinessUnit | COLUMN | |||||||||||||
| FirstName | vwWPUserBusinessUnit | COLUMN | |||||||||||||
| LastName | vwWPUserBusinessUnit | COLUMN | |||||||||||||
| Level | vwWPUserBusinessUnit | COLUMN | |||||||||||||
| Level 4 | vwWPUserBusinessUnit | COLUMN | |||||||||||||
| levelofattuid | vwWPUserBusinessUnit | COLUMN | |||||||||||||
| Level with Contractors | vwWPUserBusinessUnit | COLUMN | |||||||||||||
| Date | Date_Feedback | COLUMN | |||||||||||||
| dateDisplay | Date_Feedback | COLUMN | |||||||||||||
| 0000 tblAskATTUserList | nwcpada_0000tblaskattuserlist | COLUMN | |||||||||||||
| ATTUID | nwcpada_0000tblaskattuserlist | COLUMN | |||||||||||||
| AZ AD ID | nwcpada_0000tblaskattuserlist | COLUMN | |||||||||||||
| pvarpa_tcacknowledgement | nwcpada_0000tblaskattuserlist | COLUMN | |||||||||||||
| T&C Acknowledgement | nwcpada_0000tblaskattuserlist | COLUMN | |||||||||||||
| Azure Services | Capacity | COLUMN | |||||||||||||
| Subscription ID | Capacity | COLUMN | |||||||||||||
| Region | Capacity | COLUMN | |||||||||||||
| RPM (Shows in Quotas) 6 Requests Per 1000 Tokens | Capacity | COLUMN | |||||||||||||
| TPM (Shows in Quotas) | Capacity | COLUMN | |||||||||||||
| Total users | A measure_Keeper | MEASURE | |||||||||||||
| # of Launches | A measure_Keeper | MEASURE | |||||||||||||
| MTD (total Tokens) | A measure_Keeper | MEASURE | |||||||||||||
| YTD(Total Tokens) | A measure_Keeper | MEASURE | |||||||||||||
| Count of distinct users | A measure_Keeper | MEASURE | |||||||||||||
| Level4on | A measure_Keeper | MEASURE | |||||||||||||
| Lastdate | A measure_Keeper | MEASURE | |||||||||||||
| lastvalue | A measure_Keeper | MEASURE | |||||||||||||
| Negative Feedback | A measure_Keeper | MEASURE | |||||||||||||
| Cummulative of Feedback count | A measure_Keeper | MEASURE | |||||||||||||
| Count of no feedback | A measure_Keeper | MEASURE | |||||||||||||
| Lastcumumulative Feedback | A measure_Keeper | MEASURE | |||||||||||||
| Lastdate_Feedback | A measure_Keeper | MEASURE | |||||||||||||
| % Feedback Received | A measure_Keeper | MEASURE | |||||||||||||
| Count of comments | A measure_Keeper | MEASURE | |||||||||||||
| % with feedback With comment(Denominator- Total Response) | A measure_Keeper | MEASURE | |||||||||||||
| % with feedback With comment(Denominator- Total Feedback) | A measure_Keeper | MEASURE | |||||||||||||
| # of questions | A measure_Keeper | MEASURE | |||||||||||||
| % positive(yes/Tot feedback | A measure_Keeper | MEASURE | |||||||||||||
| % Negative(No/Tot feedback | A measure_Keeper | MEASURE | |||||||||||||
| % with feedback With no comment(Denominator- Total Questions) | A measure_Keeper | MEASURE | |||||||||||||
| % 'I don't Know' | A measure_Keeper | MEASURE |
| Name |
| DateTableTemplate_fc96fa3f-a15a-438f-a1af-5fd17c225372 |
| Date |
| Date_Feedback |
| nwcpada_0000tblaskattuserlist |
| Name | Description | Storage Mode | Source | Is Hidden |
| DateTableTemplate_fc96fa3f-a15a-438f-a1af-5fd17c225372 | Import | Calendar(Date(2015,1,1), Date(2015,1,1)) | False | |
| A measure_Keeper | Import | let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i44FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Column1"})
in
#"Removed Columns" | False | |
| pvarpa_asklillyandalex | Import | let
Source = CommonDataService.Database("org4dd70121.crm.dynamics.com"),
dbo_pvarpa_asklillyandalex = Source{[Schema="dbo",Item="pvarpa_asklillyandalex"]}[Data],
#"Removed Other Columns" = Table.SelectColumns(dbo_pvarpa_asklillyandalex,{"pvarpa_asklillyandalexid", "createdon", "pvarpa_name", "pvarpa_userid", "pvarpa_prompt", "pvarpa_textresponse", "pvarpa_model", "pvarpa_pvachatbot", "pvarpa_pvachatbotname", "pvarpa_completion_tokens", "pvarpa_prompt_tokens", "pvarpa_total_tokens", "pvarpa_attuid", "pvarpa_userfullname", "pvarpa_chat_feedback", "pvarpa_chat_feedback_comments", "nwcpada_classification", "pvarpa_codescan", "nwcpada_subclassification"}),
#"Replaced Value" = Table.ReplaceValue(#"Removed Other Columns","Lilly","Lily",Replacer.ReplaceText,{"pvarpa_name"}),
#"Cleaned Text" = Table.TransformColumns(#"Replaced Value",{{"pvarpa_prompt", Text.Clean, type text}, {"pvarpa_textresponse", Text.Clean, type text}}),
#"Duplicated Column" = Table.DuplicateColumn(#"Cleaned Text", "createdon", "createdon - Copy"),
#"Changed Type" = Table.TransformColumnTypes(#"Duplicated Column",{{"createdon - Copy", type date}}),
#"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"createdon - Copy", "createdon _Date"}}),
#"Added Custom1" = Table.AddColumn(#"Renamed Columns", "Promptwordcount", each List.Count(Text.SplitAny([pvarpa_prompt],""))),
#"Replaced Errors" = Table.ReplaceErrorValues(#"Added Custom1", {{"Promptwordcount", 0}}),
#"Added Custom" = Table.AddColumn(#"Replaced Errors", "Wordcountof anwers", each List.Count(Text.SplitAny([pvarpa_textresponse],""))),
#"Replaced Errors1" = Table.ReplaceErrorValues(#"Added Custom", {{"Wordcountof anwers", 0}}),
#"Changed Type1" = Table.TransformColumnTypes(#"Replaced Errors1",{{"Promptwordcount", Int64.Type}, {"Wordcountof anwers", Int64.Type}}),
#"Duplicated Column1" = Table.DuplicateColumn(#"Changed Type1", "createdon", "createdon - Copy"),
#"Renamed Columns1" = Table.RenameColumns(#"Duplicated Column1",{{"createdon - Copy", "createdon - Time"}}),
#"Changed Type2" = Table.TransformColumnTypes(#"Renamed Columns1",{{"createdon - Time", type time}}),
#"Sorted Rows" = Table.Sort(#"Changed Type2",{{"createdon", Order.Descending}})
in
#"Sorted Rows" | False | |
| LocalDateTable_cb263fc5-04d3-4fd2-a626-dcbd37d82c8d | Import | Calendar(Date(Year(MIN('pvarpa_asklillyandalex'[Created On])), 1, 1), Date(Year(MAX('pvarpa_asklillyandalex'[Created On])), 12, 31)) | True | |
| Date | Import | CALENDAR(MINX(pvarpa_asklillyandalex,pvarpa_asklillyandalex[Created On]),MAXX(pvarpa_asklillyandalex,pvarpa_asklillyandalex[Created On])) | False | |
| Date 2 | Import | CALENDAR(MINX(pvarpa_asklillyandalex,pvarpa_asklillyandalex[Created On]),MAXX(pvarpa_asklillyandalex,pvarpa_asklillyandalex[Created On])) | False | |
| LocalDateTable_93f2de7d-38cf-4726-ac85-50a7ec050dea | Import | Calendar(Date(Year(MIN('Date 2'[Date])), 1, 1), Date(Year(MAX('Date 2'[Date])), 12, 31)) | True | |
| LocalDateTable_080c2507-a6fd-4071-bd7d-e7517817a5c1 | Import | Calendar(Date(Year(MIN('Date 2'[dateDisplay])), 1, 1), Date(Year(MAX('Date 2'[dateDisplay])), 12, 31)) | True | |
| vwWPUserBusinessUnit | Import | let
Source = Sql.Databases("CLDPRD0SQL02735\PD_AAEXXX01"),
RPACOE = Source{[Name="RPACOE"]}[Data],
dbo_vwWPUserBusinessUnit = RPACOE{[Schema="dbo",Item="vwWPUserBusinessUnit"]}[Data],
#"Removed Other Columns" = Table.SelectColumns(dbo_vwWPUserBusinessUnit,{"ATTUID", "FirstName", "LastName", "BusinessUnitName", "ConsultantFlag", "City", "State", "CountryDesc", "Level"}),
#"Changed Type" = Table.TransformColumnTypes(#"Removed Other Columns",{{"Level", Int64.Type}}),
#"Inserted Merged Column" = Table.AddColumn(#"Changed Type", "Merged", each Text.Combine({[FirstName], [LastName]}, " "), type text),
#"Renamed Columns" = Table.RenameColumns(#"Inserted Merged Column",{{"Merged", "Full Name"}})
in
#"Renamed Columns" | False | |
| Date_Feedback | Import | CALENDAR(MINX(pvarpa_asklillyandalex,pvarpa_asklillyandalex[Created On]),MAXX(pvarpa_asklillyandalex,pvarpa_asklillyandalex[Created On])) | False | |
| LocalDateTable_3212c1da-da6b-4e83-8c1f-a5eb655307d6 | Import | Calendar(Date(Year(MIN('Date_Feedback'[dateDisplay])), 1, 1), Date(Year(MAX('Date_Feedback'[dateDisplay])), 12, 31)) | True | |
| LocalDateTable_172ea857-5685-4314-af71-76e4866a608a | Import | Calendar(Date(Year(MIN('pvarpa_asklillyandalex'[Createdon(CST)])), 1, 1), Date(Year(MAX('pvarpa_asklillyandalex'[Createdon(CST)])), 12, 31)) | True | |
| LocalDateTable_b7ee0174-7108-44a7-b6e8-3513affb1441 | Import | Calendar(Date(Year(MIN('pvarpa_asklillyandalex'[EndTime])), 1, 1), Date(Year(MAX('pvarpa_asklillyandalex'[EndTime])), 12, 31)) | True | |
| LocalDateTable_043b1470-1afe-4a99-8cda-76d0c904c8d1 | Import | Calendar(Date(Year(MIN('pvarpa_asklillyandalex'[StartTime (CT)])), 1, 1), Date(Year(MAX('pvarpa_asklillyandalex'[StartTime (CT)])), 12, 31)) | True | |
| LocalDateTable_9e2265f3-d1ef-4e9d-8f53-1a1323eac2c7 | Import | Calendar(Date(Year(MIN('Date_Feedback'[Date])), 1, 1), Date(Year(MAX('Date_Feedback'[Date])), 12, 31)) | True | |
| LocalDateTable_8f843697-64f9-4ced-8d8f-555ba0263f5f | Import | Calendar(Date(Year(MIN('pvarpa_asklillyandalex'[Feedback Date(CST)])), 1, 1), Date(Year(MAX('pvarpa_asklillyandalex'[Feedback Date(CST)])), 12, 31)) | True | |
| LocalDateTable_3aea61e1-ef40-4f52-b29e-d53d436cd9c1 | Import | Calendar(Date(Year(MIN('pvarpa_asklillyandalex'[CreatedOnDate(CST)])), 1, 1), Date(Year(MAX('pvarpa_asklillyandalex'[CreatedOnDate(CST)])), 12, 31)) | True | |
| nwcpada_0000tblaskattuserlist | Import | let
Source = CommonDataService.Database("org4dd70121.crm.dynamics.com"),
dbo_nwcpada_0000tblaskattuserlist = Source{[Schema="dbo",Item="nwcpada_0000tblaskattuserlist"]}[Data],
#"Removed Other Columns" = Table.SelectColumns(dbo_nwcpada_0000tblaskattuserlist,{"nwcpada_0000tblaskattuserlistid", "nwcpada_attuid", "nwcpada_azadid", "pvarpa_tcacknowledgement", "pvarpa_tcacknowledgementname"})
in
#"Removed Other Columns" | False | |
| LocalDateTable_0eb85fe7-c36f-4883-a4d0-e683b9d4968a | Import | Calendar(Date(Year(MIN('pvarpa_asklillyandalex'[StartTime])), 1, 1), Date(Year(MAX('pvarpa_asklillyandalex'[StartTime])), 12, 31)) | True | |
| Capacity | Import | let
Source = SharePoint.Files("https://att.sharepoint.com/sites/AboutAskATTAAA", [ApiVersion = 15]),
#"ErrorMessageIndex xlsx_https://att sharepoint com/sites/AboutAskATTAAA/Shared Documents/Reporting And Alerting/" = Source{[Name="ErrorMessageIndex.xlsx",#"Folder Path"="https://att.sharepoint.com/sites/AboutAskATTAAA/Shared Documents/Reporting And Alerting/"]}[Content],
#"Imported Excel Workbook" = Excel.Workbook(#"ErrorMessageIndex xlsx_https://att sharepoint com/sites/AboutAskATTAAA/Shared Documents/Reporting And Alerting/"),
OpenAI_Capacities_Sheet = #"Imported Excel Workbook"{[Item="OpenAI_Capacities",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(OpenAI_Capacities_Sheet, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Azure Services", type text}, {"Subscription ID", type text}, {"Region", type text}, {"Model", type text}, {"RPM (Shows in Quotas) 6 Requests Per 1000 Tokens", Int64.Type}, {"TPM (Shows in Quotas)", type text}}),
#"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([Azure Services] = "Azure OpenAI- CAST PRD") and ([Region] = "East US"))
in
#"Filtered Rows" | False |
| Measure Name | Table Name | Description | Expression | Dependency | Reverse Dependency |
|---|---|---|---|---|---|
| Count of users | A measure_Keeper | DISTINCTCOUNT ( pvarpa_asklillyandalex[userID] ) |
|
|
|
| Total users | A measure_Keeper | SUMX (
DISTINCT ( pvarpa_asklillyandalex[Name] ),
[Count of users]
) |
|
Measure: Total users | |
| # of Launches | A measure_Keeper | COUNT ( pvarpa_asklillyandalex[Created On] ) + 0 |
|
Measure: # of Launches | |
| Total Tokens used | A measure_Keeper | SUM ( pvarpa_asklillyandalex[total_tokens] ) + 0 |
|
|
|
| MTD (total Tokens) | A measure_Keeper | TOTALMTD (
SUM ( pvarpa_asklillyandalex[C_TokenCost] ),
'Date 2'[Date]
) + 0 |
|
Measure: MTD (total Tokens) | |
| QTD_TotalTokens | A measure_Keeper | TOTALQTD (
SUM ( pvarpa_asklillyandalex[C_TokenCost] ),
'Date 2'[Date]
) + 0 |
|
Measure: QTD_TotalTokens | |
| YTD(Total Tokens) | A measure_Keeper | TOTALYTD (
SUM ( pvarpa_asklillyandalex[C_TokenCost] ),
'Date 2'[Date]
) + 0 |
|
Measure: YTD(Total Tokens) | |
| Cost | A measure_Keeper | SUM ( pvarpa_asklillyandalex[C_TokenCost] ) + 0
/*VAR gpt4Cost = ( [Total Tokens used]/1000)*.12
VAR otherCost = ( [Total Tokens used]/1000)*.02
RETURN
SUMX (
'pvarpa_asklillyandalex',
IF ('pvarpa_asklillyandalex'[model] = "gpt-4-32k",
gpt4Cost,
otherCost
) + 0
) */ |
|
|
|
| Cummulative of users | A measure_Keeper | CALCULATE (
[Count of distinct users],
FILTER (
ALL ( 'Date 2'[dateDisplay] ),
'Date 2'[dateDisplay]
<= MAX ( ( 'Date 2'[dateDisplay] ) )
)
) |
|
|
|
| Count of distinct users | A measure_Keeper | DISTINCTCOUNT ( pvarpa_asklillyandalex[userID] ) |
|
|
|
| Cummulative of cost | A measure_Keeper | CALCULATE (
SUM ( pvarpa_asklillyandalex[C_TokenCost] ),
FILTER (
ALL ( 'Date 2'[dateDisplay] ),
'Date 2'[dateDisplay]
<= MAX ( ( 'Date 2'[dateDisplay] ) )
)
) |
|
|
|
| cummulative of questions | A measure_Keeper | CALCULATE (
COUNT ( pvarpa_asklillyandalex[Created On] ),
FILTER (
ALL ( 'Date 2'[dateDisplay] ),
'Date 2'[dateDisplay]
<= MAX ( ( 'Date 2'[dateDisplay] ) )
)
) |
|
|
|
| Level4on | A measure_Keeper | LOOKUPVALUE (
pvarpa_asklillyandalex[Level4up],
vwWPUserBusinessUnit[Level 4], USERPRINCIPALNAME ()
) |
|
Measure: Level4on | |
| Lastdate | A measure_Keeper | LASTDATE (
ALL ( pvarpa_asklillyandalex[createdon _Date] )
) |
|
|
|
| lastvalue | A measure_Keeper | IF (
VALUES ( 'Date 2'[dateDisplay] ) = [Lastdate],
VALUES ( pvarpa_asklillyandalex[userID] ),
BLANK ()
) |
|
Measure: lastvalue | |
| Lastcumumulative user | A measure_Keeper | CALCULATE (
[Cummulative of users],
FILTER (
'Date 2',
'Date 2'[dateDisplay] = [Lastdate]
)
) |
|
Measure: Lastcumumulative user | |
| Lastcumumulative Question | A measure_Keeper | CALCULATE (
[cummulative of questions],
FILTER (
'Date 2',
'Date 2'[dateDisplay] = [Lastdate]
)
) |
|
Measure: Lastcumumulative Question | |
| Lastest Cumumulative Cost | A measure_Keeper | CALCULATE (
[Cummulative of cost],
FILTER (
'Date 2',
'Date 2'[dateDisplay] = [Lastdate]
)
) |
|
Measure: Lastest Cumumulative Cost | |
| Avg prompt word | A measure_Keeper | DIVIDE (
SUM ( pvarpa_asklillyandalex[Promptwordcount] ),
COUNT ( pvarpa_asklillyandalex[Created On] ),
0
) |
|
Measure: Avg prompt word | |
| Avg words Response | A measure_Keeper | DIVIDE (
SUM ( pvarpa_asklillyandalex[Wordcountof anwers] ),
COUNT ( pvarpa_asklillyandalex[Created On] ),
0
) |
|
Measure: Avg words Response | |
| Positive Feedback | A measure_Keeper | CALCULATE (
COUNT ( pvarpa_asklillyandalex[Chat_Feedback] ),
pvarpa_asklillyandalex[Chat_Feedback] = "Yes"
) |
|
|
|
| Total feedback | A measure_Keeper | CALCULATE (
COUNT ( pvarpa_asklillyandalex[Chat_Feedback] )
) |
|
|
|
| Negative Feedback | A measure_Keeper | CALCULATE (
COUNT ( pvarpa_asklillyandalex[Chat_Feedback] ),
pvarpa_asklillyandalex[Chat_Feedback] = "No"
) |
|
|
|
| Cummulative of Feedback count | A measure_Keeper | CALCULATE (
[Total feedback],
FILTER (
ALL ( 'Date_Feedback' ),
'Date_Feedback'[dateDisplay]
<= MAX ( ( 'Date_Feedback'[Date] ) )
)
) |
|
|
|
| Count of no feedback | A measure_Keeper | COUNTX (
'pvarpa_asklillyandalex',
[Comment_Present] = 0
) |
|
Measure: Count of no feedback | |
| Lastcumumulative Feedback | A measure_Keeper | CALCULATE (
[Cummulative of Feedback count],
FILTER (
'Date_Feedback',
'Date_Feedback'[dateDisplay] = [Lastdate_Feedback]
)
) |
|
Measure: Lastcumumulative Feedback | |
| Lastdate_Feedback | A measure_Keeper | LASTDATE (
ALL ( pvarpa_asklillyandalex[createdon _Date] )
) |
|
|
|
| % Feedback Received | A measure_Keeper | DIVIDE (
[Total feedback],
[# of questions],
0
) |
|
Measure: % Feedback Received | |
| Count of comments | A measure_Keeper | SUM ( 'pvarpa_asklillyandalex'[Comment_Present] ) |
|
|
|
| % with feedback With comment(Denominator- Total Response) | A measure_Keeper | DIVIDE (
[Count of comments],
[# of questions],
0
) |
|
Measure: % with feedback With comment(Denominator- Total Response) | |
| % with feedback With comment(Denominator- Total Feedback) | A measure_Keeper | DIVIDE (
[Count of comments],
[Total feedback],
0
) |
|
Measure: % with feedback With comment(Denominator- Total Feedback) | |
| # of questions | A measure_Keeper | COUNT ( pvarpa_asklillyandalex[Created On] ) + 0 |
|
|
|
| % positive(yes/Tot feedback | A measure_Keeper | DIVIDE (
[Positive Feedback],
[Total feedback],
0
) |
|
Measure: % positive(yes/Tot feedback | |
| % Negative(No/Tot feedback | A measure_Keeper | DIVIDE (
[Negative Feedback],
[Total feedback],
0
) |
|
Measure: % Negative(No/Tot feedback | |
| % with feedback With no comment(Denominator- Total Questions) | A measure_Keeper | DIVIDE (
[Count of comments],
[# of questions],
0
) |
|
Measure: % with feedback With no comment(Denominator- Total Questions) | |
| Cost per User | A measure_Keeper | ( [Cost] / [Count of distinct users] ) + 0 |
|
Measure: Cost per User | |
| % 'I don't Know' | A measure_Keeper | DIVIDE (
SUM ( pvarpa_asklillyandalex[IDK Response] ),
[# of questions],
0
) |
Measure: % 'I don't Know' | Measure: % 'I don't Know' | |
| Total IDK | A measure_Keeper | CALCULATE (
COUNT ( pvarpa_asklillyandalex[IDK Response] )
) |
|
Measure: Total IDK | |
| Count Of Classification - Coding | A measure_Keeper | CALCULATE (
COUNT ( pvarpa_asklillyandalex[ClassificationWithCoding] ),
pvarpa_asklillyandalex[ClassificationWithCoding] = "Coding"
) |
|
|
|
| Count Of Classification - ATT | A measure_Keeper | CALCULATE (
COUNT ( pvarpa_asklillyandalex[ClassificationWithCoding] ),
pvarpa_asklillyandalex[ClassificationWithCoding] = "AT&T"
) |
|
|
|
| Sum Of ATT & Coding | A measure_Keeper | CALCULATE (
[Count Of Classification - ATT] + [Count Of Classification - Coding]
) |
|
|
|
| Count of All Classifications | A measure_Keeper | COUNT ( pvarpa_asklillyandalex[ClassificationWithCoding] ) |
|
|
|
| % ATT & Coding | A measure_Keeper | DIVIDE (
[Sum Of ATT & Coding],
[Count of All Classifications],
0
) |
|
Measure: % ATT & Coding |
| Column Name | Description | Calculated Column | Expression |
|---|
| Column Name | Description | Calculated Column | Expression |
|---|
| Column Name | Description | Calculated Column | Expression |
|---|---|---|---|
| 0000 Ask Lilly and Alex | |||
| Created On | |||
| Name | |||
| userID | |||
| prompt/request | |||
| text/response | |||
| model | |||
| pvarpa_pvachatbot | |||
| PVA chatbot | |||
| completion_tokens | |||
| prompt_tokens | |||
| total_tokens | |||
| Botid | Calculated Column | IF(pvarpa_asklillyandalex[Name] = "Ask Lily", "69D933B0-43C3-4D0E-9333-705CCAAA61EC",IF(pvarpa_asklillyandalex[Name]="Ask AT&T","B7CAD753-6E07-40A1-8E1B-9D126440410F",IF(pvarpa_asklillyandalex[Name]="Alex APIs","BB100714-5659-4EE3-9FC9-AAB410456532"))) | |
| ATTUID | |||
| C_TokenCost | Calculated Column | VAR gpt4Cost = ( [Total Tokens used]/1000)*.12 VAR otherCost = ( [Total Tokens used]/1000)*.02 RETURN IF ('pvarpa_asklillyandalex'[model] = "gpt-4-32k", gpt4Cost, otherCost) | |
| UserFullName | |||
| Level4up | Calculated Column | RELATED(vwWPUserBusinessUnit[Level 4]) | |
| Promptwordcount | |||
| Wordcountof anwers | |||
| Chat_Feedback | |||
| Chat_Feedback_Comments | |||
| Createdon(CST) | Calculated Column | VAR DST_START = DATE(YEAR(pvarpa_asklillyandalex[Created On]),3,1+7*2) - WEEKDAY(DATE(YEAR(pvarpa_asklillyandalex[Created On]),3,8-1)) VAR DST_END = DATE(YEAR(pvarpa_asklillyandalex[Created On]),11,1+7*1) - WEEKDAY(DATE(YEAR(pvarpa_asklillyandalex[Created On]),11,8-1)) return IF(not(ISBLANK(pvarpa_asklillyandalex[Created On])), IF ( (pvarpa_asklillyandalex[Created On] >= DST_START) && (pvarpa_asklillyandalex[Created On] <= DST_END), pvarpa_asklillyandalex[Created On] -TIME(5,0,0) , pvarpa_asklillyandalex[Created On] - TIME(6,0,0 ) ),BLANK()) | |
| StartTime | Calculated Column | DATE(YEAR(pvarpa_asklillyandalex[Created On]),MONTH(pvarpa_asklillyandalex[Created On]),DAY(pvarpa_asklillyandalex[Created On]))+TIME(HOUR(pvarpa_asklillyandalex[Created On]),MINUTE(pvarpa_asklillyandalex[Created On]),0) | |
| EndTime | Calculated Column | DATE(YEAR(pvarpa_asklillyandalex[Created On]),MONTH(pvarpa_asklillyandalex[Created On]),DAY(pvarpa_asklillyandalex[Created On]))+TIME(HOUR(pvarpa_asklillyandalex[Created On]),MINUTE(pvarpa_asklillyandalex[Created On]),0) | |
| StartTime (CT) | Calculated Column | VAR DST_START = DATE(YEAR(pvarpa_asklillyandalex[StartTime]),3,1+7*2) - WEEKDAY(DATE(YEAR(pvarpa_asklillyandalex[StartTime]),3,8-1)) VAR DST_END = DATE(YEAR(pvarpa_asklillyandalex[StartTime]),11,1+7*1) - WEEKDAY(DATE(YEAR(pvarpa_asklillyandalex[StartTime]),11,8-1)) return IF(not(ISBLANK(pvarpa_asklillyandalex[StartTime])), IF ( (pvarpa_asklillyandalex[StartTime] >= DST_START) && (pvarpa_asklillyandalex[StartTime] <= DST_END), pvarpa_asklillyandalex[StartTime] -TIME(5,0,0) , pvarpa_asklillyandalex[StartTime] - TIME(6,0,0 ) ),BLANK()) | |
| Comment_Present | Calculated Column | IF(pvarpa_asklillyandalex[Chat_Feedback_Comments]= BLANK(),0,1)+0 | |
| Feedback Date(CST) | Calculated Column | VAR DST_START = DATE(YEAR(pvarpa_asklillyandalex[createdon _Date]),3,1+7*2) - WEEKDAY(DATE(YEAR(pvarpa_asklillyandalex[createdon _Date]),3,8-1)) VAR DST_END = DATE(YEAR(pvarpa_asklillyandalex[createdon _Date]),11,1+7*1) - WEEKDAY(DATE(YEAR(pvarpa_asklillyandalex[createdon _Date]),11,8-1)) return IF(not(ISBLANK(pvarpa_asklillyandalex[createdon _Date])), IF ( (pvarpa_asklillyandalex[createdon _Date] >= DST_START) && (pvarpa_asklillyandalex[createdon _Date] <= DST_END), pvarpa_asklillyandalex[createdon _Date] -TIME(5,0,0) , pvarpa_asklillyandalex[createdon _Date] - TIME(6,0,0 ) ),BLANK()) | |
| CreatedOnDate(CST) | Calculated Column | pvarpa_asklillyandalex[Createdon(CST)].[Date] | |
| IDK Response | Calculated Column | IF( SEARCH("I don't know", 'pvarpa_asklillyandalex'[text/response], 1, 0) > 0, 1, 0 )+ 0 | |
| Classification | |||
| ClassificationWithCoding | Calculated Column | VAR ClassText = "Coding" VAR Classification = pvarpa_asklillyandalex[Classification] VAR SubClass = pvarpa_asklillyandalex[CodeSubClassification] RETURN IF ( Classification = ClassText, "Coding", IF ( SubClass = "Not Coding", IF ( LEN(Classification) > 20 || LEN(Classification) < 2, "Unclassified", Classification ), "Coding" ) ) | |
| CreatedOnHour | Calculated Column | HOUR('pvarpa_asklillyandalex'[Created On]) | |
| Created On (Min) | Calculated Column | IF( ISBLANK('pvarpa_asklillyandalex'[Created On]), BLANK(), INT('pvarpa_asklillyandalex'[Created On] * 1440) / 1440 ) | |
| RecordsPerMinute | Calculated Column | COUNTROWS('pvarpa_asklillyandalex') / DISTINCTCOUNT('pvarpa_asklillyandalex'[Created On (Min)]) | |
| Created On (hr) | Calculated Column | IF( ISBLANK('pvarpa_asklillyandalex'[Created On]), BLANK(), INT('pvarpa_asklillyandalex'[Created On] * 24) / 24 ) | |
| createdon - Time | |||
| CodeSubClassification | Calculated Column | VAR ClassText = "Coding" VAR Classification = pvarpa_asklillyandalex[Classification] RETURN IF ( Classification = ClassText, "Old Code Class", IF ( LEFT(Classification,6) = ClassText , RIGHT(Classification, LEN(Classification)-7) , "Not Coding" ) ) | |
| CodeScan | |||
| SubClassification | |||
| Createdon(CST) (Minute) | Calculated Column | IF( ISBLANK('pvarpa_asklillyandalex'[Createdon(CST)]), BLANK(), INT('pvarpa_asklillyandalex'[Createdon(CST)] * 1440) / 1440 ) |
| Column Name | Description | Calculated Column | Expression |
|---|---|---|---|
| Date | |||
| dateDisplay | Calculated Column | FORMAT([date], "MM/DD/YY") |
| Column Name | Description | Calculated Column | Expression |
|---|---|---|---|
| Date | |||
| dateDisplay | Calculated Column | FORMAT([date], "MM/DD/YY") | |
| Today | Calculated Column | IF('Date 2'[dateDisplay]=TODAY(),true,false) |
| Column Name | Description | Calculated Column | Expression |
|---|---|---|---|
| ATTUID | |||
| FirstName | |||
| LastName | |||
| BusinessUnitName | |||
| Level | |||
| Level 4 | Calculated Column | IF(vwWPUserBusinessUnit[Level] >= 4,vwWPUserBusinessUnit[ATTUID],BLANK()) | |
| levelofattuid | Calculated Column | IF(vwWPUserBusinessUnit[ATTUID] <> BLANK(),vwWPUserBusinessUnit[Level],BLANK()) | |
| Full Name | |||
| Level with Contractors | Calculated Column | IF(vwWPUserBusinessUnit[ConsultantFlag] = "Y", 0, vwWPUserBusinessUnit[Level]) | |
| ConsultantFlag | |||
| City | |||
| State | |||
| CountryDesc |
| Column Name | Description | Calculated Column | Expression |
|---|---|---|---|
| Date | |||
| dateDisplay | Calculated Column | FORMAT([date], "MM/DD/YY") |
| Column Name | Description | Calculated Column | Expression |
|---|---|---|---|
| 0000 tblAskATTUserList | |||
| ATTUID | |||
| AZ AD ID | |||
| pvarpa_tcacknowledgement | |||
| T&C Acknowledgement |
| Column Name | Description | Calculated Column | Expression |
|---|---|---|---|
| Azure Services | |||
| Subscription ID | |||
| Region | |||
| Model | |||
| RPM (Shows in Quotas) 6 Requests Per 1000 Tokens | |||
| TPM (Shows in Quotas) |
| Role Name | Table Name | Description | Expression |
|---|
| Name | CrossFilteringBehavior | FromCardinality | FromColumn | FromTable | IsActive | IsRemoved | JoinOnDateBehavior | RelyOnReferentialIntegrity | SecurityFilteringBehavior | State | ToCardinality | ToColumn | ToTable | Type |
| 55d26519-4744-46ef-90c7-a53b2cb419d5 | OneDirection | Many | Created On | pvarpa_asklillyandalex | True | False | DatePartOnly | False | OneDirection | Ready | One | Date | LocalDateTable_cb263fc5-04d3-4fd2-a626-dcbd37d82c8d | SingleColumn |
| bac67ae8-bf98-45d2-97b3-6c2df25d212e | OneDirection | Many | Date | Date 2 | True | False | DatePartOnly | False | OneDirection | Ready | One | Date | LocalDateTable_93f2de7d-38cf-4726-ac85-50a7ec050dea | SingleColumn |
| 3419028d-c1fe-47bd-a796-7ee47dbace62 | OneDirection | Many | dateDisplay | Date 2 | True | False | DatePartOnly | False | OneDirection | Ready | One | Date | LocalDateTable_080c2507-a6fd-4071-bd7d-e7517817a5c1 | SingleColumn |
| 77a5a04f-0567-457f-a905-6072208762b2 | OneDirection | Many | createdon _Date | pvarpa_asklillyandalex | True | False | DateAndTime | False | OneDirection | Ready | One | dateDisplay | Date 2 | SingleColumn |
| 1db839d5-a5db-4c37-b39a-9ad9d8beb93d | OneDirection | Many | dateDisplay | Date_Feedback | True | False | DatePartOnly | False | OneDirection | Ready | One | Date | LocalDateTable_3212c1da-da6b-4e83-8c1f-a5eb655307d6 | SingleColumn |
| 3c85cbfc-baf3-420a-bf43-7dbb9a14cbe0 | OneDirection | Many | ATTUID | pvarpa_asklillyandalex | True | False | DateAndTime | False | OneDirection | Ready | One | ATTUID | vwWPUserBusinessUnit | SingleColumn |
| b9915fac-9fa0-420c-bb28-53f2ca4b1e9d | OneDirection | Many | Createdon(CST) | pvarpa_asklillyandalex | True | False | DatePartOnly | False | OneDirection | Ready | One | Date | LocalDateTable_172ea857-5685-4314-af71-76e4866a608a | SingleColumn |
| 8fd00490-6c17-4cf2-ab14-a48aa6449de3 | OneDirection | Many | EndTime | pvarpa_asklillyandalex | True | False | DatePartOnly | False | OneDirection | Ready | One | Date | LocalDateTable_b7ee0174-7108-44a7-b6e8-3513affb1441 | SingleColumn |
| 46cc8616-2fc9-471f-9fa2-be747bcc55fd | OneDirection | Many | StartTime (CT) | pvarpa_asklillyandalex | True | False | DatePartOnly | False | OneDirection | Ready | One | Date | LocalDateTable_043b1470-1afe-4a99-8cda-76d0c904c8d1 | SingleColumn |
| 86f6be09-fb68-4334-a8b5-96e90d0c5129 | OneDirection | Many | Date | Date_Feedback | True | False | DatePartOnly | False | OneDirection | Ready | One | Date | LocalDateTable_9e2265f3-d1ef-4e9d-8f53-1a1323eac2c7 | SingleColumn |
| 9fd511e0-c57d-4aa9-8ad4-2495e094fe63 | OneDirection | Many | Feedback Date(CST) | pvarpa_asklillyandalex | True | False | DatePartOnly | False | OneDirection | Ready | One | Date | LocalDateTable_8f843697-64f9-4ced-8d8f-555ba0263f5f | SingleColumn |
| 56ed23d4-d430-4f31-abfd-7d7369a08789 | OneDirection | Many | CreatedOnDate(CST) | pvarpa_asklillyandalex | True | False | DatePartOnly | False | OneDirection | Ready | One | Date | LocalDateTable_3aea61e1-ef40-4f52-b29e-d53d436cd9c1 | SingleColumn |
| f934a070-2dce-4f7a-91b6-7f1ff12ea890 | OneDirection | Many | ATTUID | nwcpada_0000tblaskattuserlist | True | False | DateAndTime | False | OneDirection | Ready | One | ATTUID | vwWPUserBusinessUnit | SingleColumn |
| 5a0b8e2b-0e46-4816-b70e-c8f10352d697 | OneDirection | Many | StartTime | pvarpa_asklillyandalex | True | False | DatePartOnly | False | OneDirection | Ready | One | Date | LocalDateTable_0eb85fe7-c36f-4883-a4d0-e683b9d4968a | SingleColumn |
| Name | QueryDefinition |
| DateTableTemplate_fc96fa3f-a15a-438f-a1af-5fd17c225372-44a811c0-558a-4053-8714-685a0f896286 | Calendar(Date(2015,1,1), Date(2015,1,1)) |
| A measure_Keeper-71783203-fa7a-41ed-be6a-425a4121ed13 | let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i44FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Column1 = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}), #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Column1"}) in #"Removed Columns" |
| pvarpa_asklillyandalex-181578a1-f4d8-43f1-a137-da7875370677 | let Source = CommonDataService.Database("org4dd70121.crm.dynamics.com"), dbo_pvarpa_asklillyandalex = Source{[Schema="dbo",Item="pvarpa_asklillyandalex"]}[Data], #"Removed Other Columns" = Table.SelectColumns(dbo_pvarpa_asklillyandalex,{"pvarpa_asklillyandalexid", "createdon", "pvarpa_name", "pvarpa_userid", "pvarpa_prompt", "pvarpa_textresponse", "pvarpa_model", "pvarpa_pvachatbot", "pvarpa_pvachatbotname", "pvarpa_completion_tokens", "pvarpa_prompt_tokens", "pvarpa_total_tokens", "pvarpa_attuid", "pvarpa_userfullname", "pvarpa_chat_feedback", "pvarpa_chat_feedback_comments", "nwcpada_classification", "pvarpa_codescan", "nwcpada_subclassification"}), #"Replaced Value" = Table.ReplaceValue(#"Removed Other Columns","Lilly","Lily",Replacer.ReplaceText,{"pvarpa_name"}), #"Cleaned Text" = Table.TransformColumns(#"Replaced Value",{{"pvarpa_prompt", Text.Clean, type text}, {"pvarpa_textresponse", Text.Clean, type text}}), #"Duplicated Column" = Table.DuplicateColumn(#"Cleaned Text", "createdon", "createdon - Copy"), #"Changed Type" = Table.TransformColumnTypes(#"Duplicated Column",{{"createdon - Copy", type date}}), #"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"createdon - Copy", "createdon _Date"}}), #"Added Custom1" = Table.AddColumn(#"Renamed Columns", "Promptwordcount", each List.Count(Text.SplitAny([pvarpa_prompt],""))), #"Replaced Errors" = Table.ReplaceErrorValues(#"Added Custom1", {{"Promptwordcount", 0}}), #"Added Custom" = Table.AddColumn(#"Replaced Errors", "Wordcountof anwers", each List.Count(Text.SplitAny([pvarpa_textresponse],""))), #"Replaced Errors1" = Table.ReplaceErrorValues(#"Added Custom", {{"Wordcountof anwers", 0}}), #"Changed Type1" = Table.TransformColumnTypes(#"Replaced Errors1",{{"Promptwordcount", Int64.Type}, {"Wordcountof anwers", Int64.Type}}), #"Duplicated Column1" = Table.DuplicateColumn(#"Changed Type1", "createdon", "createdon - Copy"), #"Renamed Columns1" = Table.RenameColumns(#"Duplicated Column1",{{"createdon - Copy", "createdon - Time"}}), #"Changed Type2" = Table.TransformColumnTypes(#"Renamed Columns1",{{"createdon - Time", type time}}), #"Sorted Rows" = Table.Sort(#"Changed Type2",{{"createdon", Order.Descending}}) in #"Sorted Rows" |
| LocalDateTable_cb263fc5-04d3-4fd2-a626-dcbd37d82c8d-5472c01a-5521-4325-921d-f32b40a09fda | Calendar(Date(Year(MIN('pvarpa_asklillyandalex'[Created On])), 1, 1), Date(Year(MAX('pvarpa_asklillyandalex'[Created On])), 12, 31)) |
| Date-39d1c154-755c-4f7b-bc40-0c178ee62a64 | CALENDAR(MINX(pvarpa_asklillyandalex,pvarpa_asklillyandalex[Created On]),MAXX(pvarpa_asklillyandalex,pvarpa_asklillyandalex[Created On])) |
| Date 2-32d02b8f-b3ce-4536-80ee-babea2a2b890 | CALENDAR(MINX(pvarpa_asklillyandalex,pvarpa_asklillyandalex[Created On]),MAXX(pvarpa_asklillyandalex,pvarpa_asklillyandalex[Created On])) |
| LocalDateTable_93f2de7d-38cf-4726-ac85-50a7ec050dea-cf91aaa2-368d-410c-bbde-84a712d524d4 | Calendar(Date(Year(MIN('Date 2'[Date])), 1, 1), Date(Year(MAX('Date 2'[Date])), 12, 31)) |
| LocalDateTable_080c2507-a6fd-4071-bd7d-e7517817a5c1-ac0d6ba3-aa46-4bc6-8584-c25f5cbeec9a | Calendar(Date(Year(MIN('Date 2'[dateDisplay])), 1, 1), Date(Year(MAX('Date 2'[dateDisplay])), 12, 31)) |
| vwWPUserBusinessUnit-59f77ec7-d9af-457f-b4c9-ac0e9436f239 | let Source = Sql.Databases("CLDPRD0SQL02735\PD_AAEXXX01"), RPACOE = Source{[Name="RPACOE"]}[Data], dbo_vwWPUserBusinessUnit = RPACOE{[Schema="dbo",Item="vwWPUserBusinessUnit"]}[Data], #"Removed Other Columns" = Table.SelectColumns(dbo_vwWPUserBusinessUnit,{"ATTUID", "FirstName", "LastName", "BusinessUnitName", "ConsultantFlag", "City", "State", "CountryDesc", "Level"}), #"Changed Type" = Table.TransformColumnTypes(#"Removed Other Columns",{{"Level", Int64.Type}}), #"Inserted Merged Column" = Table.AddColumn(#"Changed Type", "Merged", each Text.Combine({[FirstName], [LastName]}, " "), type text), #"Renamed Columns" = Table.RenameColumns(#"Inserted Merged Column",{{"Merged", "Full Name"}}) in #"Renamed Columns" |
| Date_Feedback-581cf1f8-42e3-424f-a1b6-cca2702c171f | CALENDAR(MINX(pvarpa_asklillyandalex,pvarpa_asklillyandalex[Created On]),MAXX(pvarpa_asklillyandalex,pvarpa_asklillyandalex[Created On])) |
| LocalDateTable_3212c1da-da6b-4e83-8c1f-a5eb655307d6-00b617e4-02fa-4793-a3b9-9acc2e0d2e1d | Calendar(Date(Year(MIN('Date_Feedback'[dateDisplay])), 1, 1), Date(Year(MAX('Date_Feedback'[dateDisplay])), 12, 31)) |
| LocalDateTable_172ea857-5685-4314-af71-76e4866a608a-304d6a44-fed7-4102-95f1-e315f3670409 | Calendar(Date(Year(MIN('pvarpa_asklillyandalex'[Createdon(CST)])), 1, 1), Date(Year(MAX('pvarpa_asklillyandalex'[Createdon(CST)])), 12, 31)) |
| LocalDateTable_b7ee0174-7108-44a7-b6e8-3513affb1441-4aa819e2-6b2b-4de4-980f-f47bd181d7f1 | Calendar(Date(Year(MIN('pvarpa_asklillyandalex'[EndTime])), 1, 1), Date(Year(MAX('pvarpa_asklillyandalex'[EndTime])), 12, 31)) |
| LocalDateTable_043b1470-1afe-4a99-8cda-76d0c904c8d1-841a574b-114b-468d-a87d-306f1e6d0ab2 | Calendar(Date(Year(MIN('pvarpa_asklillyandalex'[StartTime (CT)])), 1, 1), Date(Year(MAX('pvarpa_asklillyandalex'[StartTime (CT)])), 12, 31)) |
| LocalDateTable_9e2265f3-d1ef-4e9d-8f53-1a1323eac2c7-dd7d9f1e-aa16-406e-b9ba-e1b6338c8950 | Calendar(Date(Year(MIN('Date_Feedback'[Date])), 1, 1), Date(Year(MAX('Date_Feedback'[Date])), 12, 31)) |
| LocalDateTable_8f843697-64f9-4ced-8d8f-555ba0263f5f-4bfb58af-43dc-47d5-94eb-72e6418c8434 | Calendar(Date(Year(MIN('pvarpa_asklillyandalex'[Feedback Date(CST)])), 1, 1), Date(Year(MAX('pvarpa_asklillyandalex'[Feedback Date(CST)])), 12, 31)) |
| LocalDateTable_3aea61e1-ef40-4f52-b29e-d53d436cd9c1-83a9b55e-754a-4410-9113-37a3b9cde4a1 | Calendar(Date(Year(MIN('pvarpa_asklillyandalex'[CreatedOnDate(CST)])), 1, 1), Date(Year(MAX('pvarpa_asklillyandalex'[CreatedOnDate(CST)])), 12, 31)) |
| nwcpada_0000tblaskattuserlist-fbac5d01-71c9-426e-9e73-aa109bdac41a | let Source = CommonDataService.Database("org4dd70121.crm.dynamics.com"), dbo_nwcpada_0000tblaskattuserlist = Source{[Schema="dbo",Item="nwcpada_0000tblaskattuserlist"]}[Data], #"Removed Other Columns" = Table.SelectColumns(dbo_nwcpada_0000tblaskattuserlist,{"nwcpada_0000tblaskattuserlistid", "nwcpada_attuid", "nwcpada_azadid", "pvarpa_tcacknowledgement", "pvarpa_tcacknowledgementname"}) in #"Removed Other Columns" |
| LocalDateTable_0eb85fe7-c36f-4883-a4d0-e683b9d4968a-af4f850c-d782-4d09-9bff-b5ca8a479f13 | Calendar(Date(Year(MIN('pvarpa_asklillyandalex'[StartTime])), 1, 1), Date(Year(MAX('pvarpa_asklillyandalex'[StartTime])), 12, 31)) |
| Capacity-1850cdc5-3921-4b14-afcc-5fc467e96df2 | let Source = SharePoint.Files("https://att.sharepoint.com/sites/AboutAskATTAAA", [ApiVersion = 15]), #"ErrorMessageIndex xlsx_https://att sharepoint com/sites/AboutAskATTAAA/Shared Documents/Reporting And Alerting/" = Source{[Name="ErrorMessageIndex.xlsx",#"Folder Path"="https://att.sharepoint.com/sites/AboutAskATTAAA/Shared Documents/Reporting And Alerting/"]}[Content], #"Imported Excel Workbook" = Excel.Workbook(#"ErrorMessageIndex xlsx_https://att sharepoint com/sites/AboutAskATTAAA/Shared Documents/Reporting And Alerting/"), OpenAI_Capacities_Sheet = #"Imported Excel Workbook"{[Item="OpenAI_Capacities",Kind="Sheet"]}[Data], #"Promoted Headers" = Table.PromoteHeaders(OpenAI_Capacities_Sheet, [PromoteAllScalars=true]), #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Azure Services", type text}, {"Subscription ID", type text}, {"Region", type text}, {"Model", type text}, {"RPM (Shows in Quotas) 6 Requests Per 1000 Tokens", Int64.Type}, {"TPM (Shows in Quotas)", type text}}), #"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([Azure Services] = "Azure OpenAI- CAST PRD") and ([Region] = "East US")) in #"Filtered Rows" |