sql prices_selected_zone
select "time" at time zone 'UTC' at time zone 'Europe/Amsterdam' as mtu, ${inputs.selected_zone.value} as price
from ${prices}
order by time asc

Error: Invalid Input Error: File 'needful_things_orders.parquet' too small to be a Parquet file

mysql2

@evidence-dev/mysql

"node_modules/@evidence-dev/mysql": {
      "version": "1.1.1",
      "resolved": "<https://registry.npmjs.org/@evidence-dev/mysql/-/mysql-1.1.1.tgz>",
      "integrity": "sha512-KPAI7HinbEggxxAOCILWjT6Ylxci7PMvwrhKu17HfWNb+KCrDNGxdcFiIu/daKV02sopsri0Muuxn1mJO70kfg==",
      "peer": true,
      "dependencies": {
        "@evidence-dev/db-commons": "1.0.4",
        "mysql2": "^3.8.0"
      }
    },

@evidence-dev/db-orchestrator

PS C:\Users\dan\dev\evidence> npm install @evidence-dev/evidence@latest @evidence-dev/core-components@latest
npm ERR! code ERESOLVE
npm ERR! ERESOLVE could not resolve
npm ERR! 
npm ERR! While resolving: my-evidence-project@0.0.1
npm ERR! Found: @evidence-dev/evidence@29.0.2
npm ERR! node_modules/@evidence-dev/evidence
npm ERR!   @evidence-dev/evidence@"32.0.1" from the root project
npm ERR! 
npm ERR! Could not resolve dependency:
npm ERR! @evidence-dev/evidence@"32.0.1" from the root project
npm ERR! 
npm ERR! Conflicting peer dependency: @sveltejs/kit@2.5.4
npm ERR! node_modules/@sveltejs/kit
npm ERR!   peer @sveltejs/kit@"2.5.4" from @evidence-dev/evidence@32.0.1
npm ERR!   node_modules/@evidence-dev/evidence
npm ERR!     @evidence-dev/evidence@"32.0.1" from the root project
npm ERR! 
npm ERR! Fix the upstream dependency conflict, or retry
npm ERR! this command with --force or --legacy-peer-deps
npm ERR! to accept an incorrect (and potentially broken) dependency resolution.
npm ERR! 
npm ERR! 
npm ERR! For a full report see:
npm ERR! C:\Users\dan\AppData\Local\npm-cache\_logs\2024-04-16T20_14_39_333Z-eresolve-report.txt

npm ERR! A complete log of this run can be found in: C:\Users\dan\AppData\Local\npm-cache\_logs\2024-04-16T20_14_39_333Z-debug-0.log

npm run build:strict

node:internal/event_target:1100
  process.nextTick(() => { throw err; });
                           ^
Error: 500 /
To suppress or handle this error, implement `handleHttpError` in <https://kit.svelte.dev/docs/configuration#prerender>
    at file:///home/runner/work/filecoin-pulse/filecoin-pulse/node_modules/@sveltejs/kit/src/core/config/options.js:202:13
    at file:///home/runner/work/filecoin-pulse/filecoin-pulse/node_modules/@sveltejs/kit/src/core/postbuild/prerender.js:65:25
    at save (file:///home/runner/work/filecoin-pulse/filecoin-pulse/node_modules/@sveltejs/kit/src/core/postbuild/prerender.js:403:4)
    at visit (file:///home/runner/work/filecoin-pulse/filecoin-pulse/node_modules/@sveltejs/kit/src/core/postbuild/prerender.js:236:3)
Emitted 'error' event on Worker instance at:
    at [kOnErrorMessage] (node:internal/worker:326:10)
    at [kOnMessage] (node:internal/worker:337:37)
    at MessagePort.<anonymous> (node:internal/worker:232:57)
    at [nodejs.internal.kHybridDispatch] (node:internal/event_target:826:20)
    at MessagePort.<anonymous> (node:internal/per_context/messageport:23:28)

Node.js v20.12.2
Build failed

file:///home/runner/work/filecoin-pulse/filecoin-pulse/node_modules/@evidence-dev/evidence/cli.js:179
			throw `Build process exited with code ${code}`;
			^
Build process exited with code 1
(Use `node --trace-uncaught ...` to show where the exception was thrown)

---
queries:
  - q4_data: my_file_query.sql
  - q4_sales_reps: some_category/my_category_file_query.sql
---

mitch-dev

---
# queires that generate the data.
queries:  
#--Monthly
- monthly_tech_overtime: technician_overtime/monthly_tech_overtime.sql  
- monthly_stat_count: technician_overtime/monthly_stat_count.sql
- total_count_employee: technician_overtime/total_count_employee.sql

#--Weekly
- weekly_tech_overtime: technician_overtime/weekly_tech_overtime.sql
- weekly_stat_count: technician_overtime/weekly_stat_count.sql
- w_total_count_employee: technician_overtime/w_total_count_employee.sql
---


<Grid cols=3 gapSize="sm">
  <Dropdown name=year_of_dropdown title="Select Year">
    <DropdownOption valueLabel="2024" value=2024 />
    <DropdownOption valueLabel="2023" value=2023 />
  </Dropdown>
  <Dropdown name=season_of_dropdown title="Select Seasonality">
    <DropdownOption valueLabel="Monthly" value="Monthly" />
    <DropdownOption valueLabel="Weekly" value="Weekly" />
  </Dropdown>  
  <Dropdown name=division_of_dropdown  title="Select Maintenance Division">
    <DropdownOption valueLabel="VIC" value="VIC" />
    <DropdownOption valueLabel="NSW" value="NSW" />
    <DropdownOption valueLabel="OLD" value="QLD" />
    <DropdownOption valueLabel="SA" value="SA" />
    <DropdownOption valueLabel="WA" value="WA" />
    <DropdownOption valueLabel="NT" value="NT" />
    <DropdownOption valueLabel="TAS" value="TAS" />
    <DropdownOption valueLabel="ACT" value="ACT" />
  </Dropdown>
</Grid>


{#if inputs.season_of_dropdown.value === 'Monthly'}
  <Histogram
    data={monthly_tech_overtime}
    x=Total_count
    yAxisTitle="Number of Observed Technicians"
    xAxisTitle="Technician Overtime Instances"
    yGridlines=false
    colorPalette={['#01bcff','#010320']}
   title=""
   chartAreaHeight=250
  >
    <ReferenceLine x={monthly_stat_count[0].outlier} label="Threshold" color=black labelColor=black lineWidth=2/>
    <ReferenceArea xMin={monthly_stat_count[0].outlier}  xMax={monthly_stat_count[0].max_total_count+10} 
    label="Unusual Overtime" color='#eeeeee' labelPosition=center labelColor=black />
  </Histogram>

_**Insights**_: _<Value data={total_count_employee}  column=prob_total_count_employee fmt=pct0 />_ of technicians booked overtime to maintenance more than _<Value data={monthly_stat_count} column=outlier />_ times. The heat map below identifies those technicians and includes the month they booked overtime. 

{:else if inputs.season_of_dropdown.value === 'Weekly'}
  <Histogram
    data={weekly_tech_overtime}
    x=Total_count
    yAxisTitle="Number of Observed Technicians"
    xAxisTitle="Technician Overtime Instances"
    yGridlines=false
    colorPalette={['#01bcff','#010320']}
   title=""
   chartAreaHeight=250
  >
    <ReferenceLine x={weekly_stat_count[0].outlier} label="Threshold" color=black labelColor=black lineWidth=2/>
    <ReferenceArea xMin={weekly_stat_count[0].outlier}  xMax={weekly_stat_count[0].max_total_count+10} 
    label="Unusual Overtime" color='#eeeeee' labelPosition=center labelColor=black />
  </Histogram>

_**Insights**_: _<Value data={w_total_count_employee}  column=prob_total_count_employee fmt=pct0 />_ of technicians booked overtime to maintenance more than _<Value data={weekly_stat_count} column=outlier />_ times. The heat map below identifies those technicians and includes the month they booked overtime. 

{:else }

Something completely different.