PBI-DataVizzle
/ fnErlangC.pq
Created
November 19, 2023 14:31
— forked from cbaragao/fnErlangC.pq
Erlang C calculation in Power Query
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| let | |
| fnErlangC = | |
| ( | |
| number_of_calls as number, | |
| period_of_minutes as number, | |
| average_handling_time as number, | |
| required_service_level as number, | |
| target_answer_time as number, | |
| maximum_occupancy as number, |
PBI-DataVizzle
/ fnHoltWinters.pq
Created
November 19, 2023 14:31
— forked from cbaragao/fnHoltWinters.pq
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| Function: fnHoltWinters | |
| Description: Trying to replicate HoltWinters quantitative smoothing with Power Query. | |
| Author: Chris Aragao | |
| Change Log: | |
| 11.13.2023 - Initial release. Initial code was based off of this tutorial: https://www.exceldemy.com/holt-winters-exponential-smoothing-in-excel/. | |
| It was aimed at solely duplicating the output and did so. |
PBI-DataVizzle
/ Sparkline_SVG_Card.txt
Created
November 19, 2023 14:31
— forked from cbaragao/Sparkline_SVG_Card.txt
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Sparkline = | |
| // dummy value in a table | |
| VAR _vals = { | |
| ( 0, 500 ), | |
| ( 1, 700 ), | |
| ( 2, 1200 ), | |
| ( 3, 1250 ), | |
| ( 4, 550 ), | |
| ( 5, 780 ), | |
| ( 6, 990 ), |
PBI-DataVizzle
/ target_card.txt
Created
November 19, 2023 14:30
— forked from cbaragao/target_card.txt
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| target card = | |
| // unsat, below, near, hit | |
| VAR _Q1_result = "unsat" | |
| VAR _Q2_result = "below" | |
| VAR _Q3_result = "near" | |
| VAR _Q4_result = "hit" |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| https://vega.github.io/editor/#/url/vega-lite/N4KABGBEAWCmCWBzaAXSAuMBWADDgNOFAO7wAmK0G2ehEkZAhio9aBBOJAG6MA2AV1gBnagG0iEdhxmQAmrEYAnagEYAnLjoyOkAKoA5agDsBfPtp1QAkgAkAsgFETZi5J2Rr1gIIBlby7mlh6GAPq28MIoAPZK8ADG-NQATAAsAOzpAGzpuLTushHIsCqYpkEFugAy0cQlgW5W9AAizLDUkDiqAPRd3Rq4kO4AvsHSVvKKpWADqsGyhg3zunZOS5X0Xn4BZa7L9GERUbEJSZjJWMk46ul4+U1QRXDT5Y1NkDV1L3sbUK0o7UwnR6fVmQxko3c4w8CmUak0yX2UEWuwqD08DmcqLeEy2-nW6MOkRicUSfBSWCyl3UqjuSMgT3q2PpnyZYFe9P+gKgfVBCPBHEhMmhslh0wGAGZ6Sj2T90assbK0e88TslTiQgZwsSTmSUllVJcsLT7u9Gd9lRNWRaNbIuR1eT1JQKIEKOCLdGL4VhUtKjMzfhi1gH5T58SH3kTjqSzmBklkqRKcLdTRNzQT3taMxN7UDHf1NKkXWA3VJA17MAMsH7sx4FbXZKqG7ooyTTuTzulVAAOKlXVMedMRq21NkcwO5nkgp2aLDF0tgD30CszTRZGvDuuY5ubMNq8eErVHNt6zvpCWpdRJgeFJDPHdQLObu1tB3TguU+djctTb3pDfqvS9bPise4PvoR46jGHZxt2yTdsa14EIGQ6AYGT5oeik7Ar0M5YOkX5Qj+cKVpo3YAQeKrbiBu7bOBra6rG8HdukyTJCayHoqhlEjl84HYfmAzdoRwrEeKmjqBRcpUcGmEqmBNHIpB0btik6ipJemh0ihd5jtJvF6ZaHgCe+AzqCJ7pifCWScZG-pybi1EOXWCnOQsyknkx6izt26jaVxuk2iyo5BROr55qZ6g2RZZboiuGgGlJRmNk5PEuXRikQdqKmnmASapPB6Tdv5ZqBeBGFpS+ |
PBI-DataVizzle
/ UN_Population.json
Created
November 11, 2023 20:56
UN Population Chart for Vega-Lite Online Editor
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "data": { | |
| "values": [ | |
| { | |
| "Year": 1950, | |
| "UN": null, | |
| "IHME": null, | |
| "IIASA": null, | |
| "UN_Historical": 2477675000, | |
| "Higher": null, |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "$schema": "https://vega.github.io/schema/vega-lite/v5.json", | |
| "usermeta": { | |
| "deneb": { | |
| "build": "1.5.1.0", | |
| "metaVersion": 1, | |
| "provider": "vegaLite", | |
| "providerVersion": "5.6.1" | |
| }, | |
| "interactivity": { |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "title": { | |
| "text": "% Rating based on Category Type", | |
| "anchor": "middle", | |
| "color": "white", | |
| "font": "helvatica", | |
| "fontSize": 30 | |
| }, | |
| "data": { | |
| "values": [ |
PBI-DataVizzle
/ pbi_theme_headericons.json
Last active
August 25, 2023 14:10
pbi_theme_Global_HeaderIcons
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "name": "My New Theme", | |
| "visualStyles": { | |
| "*": { | |
| "*": { | |
| "visualHeader": [{ | |
| "show": false, | |
| "showOptionsMenu": false, | |
| "transparency": 0, | |
| "foreground": { |