3 ms·
Is that because of unfamiliarity with org syntax or something else? Current org approach of using code and data is already standardized and used in many organiz
by newusertoday 5y ago
Is that because of unfamiliarity with org syntax or something else? Current org approach of using code and data is already standardized and used in many organizations.
So the value add is new approach by restricting it to markdown and only supporting sql and restricted set of components?
1.
here is plot equivalent of evidence
#+plot: set:"xlabel 'day_of_year '" set:"ylabel 'cum_vol'"
<LineChart data={data.daily_volume_yoy} x=day_of_year y=cum_vol series=year
units="cumulative calls"
xAxisTitle="day of year"/>
2. sql equivatent, note that org mode also supports other languages i.e. python/bash etc. that is the reason you need to specify sqlite here
#+begin_src sqlite :db users.db :colnames yes
select
count() as total_calls,
countif(timestamp_diff(current_timestamp(), created_date, day) <7) as calls_in_the_last_7_days,
countif(timestamp_diff(current_timestamp(), created_date, day) <365) as calls_in_the_last_365_days,
min(created_date) as earliest_call_date,
max(created_date) as latest_call_date
from `bigquery-public-data.austin_311.311_service_requests`
limit 1
#+end_src
```summary
select
count() as total_calls,
countif(timestamp_diff(current_timestamp(), created_date, day) <7) as calls_in_the_last_7_days,
countif(timestamp_diff(current_timestamp(), created_date, day) <365) as calls_in_the_last_365_days,
min(created_date) as earliest_call_date,
max(created_date) as latest_call_date
from `bigquery-public-data.austin_311.311_service_requests`
limit 1
```
3. Document
* Recent Call Volume Spikes
# Recent Call Volume Spikes
- bayesian_horse 5y agoGood luck getting non-emacs users to adopt emacs for this purpose. Of course you know that Emacs is the Best there is. It's just that ordinary people seem take so much convincing... And still, your code has lots of "line noise", so I consider it uglier, but that's a personal preference.