timothyrenner / svl

A declarative language for dashboards and reports
https://timothyrenner.github.io/svl
MIT License
8 stars 1 forks source link

Add Big Number #66

Closed timothyrenner closed 4 years ago

timothyrenner commented 4 years ago

If you've got big number needs you need a big number. Something like this:

NUMBER bigfoot 
    report_id COUNT -- can be field, aggregation, or transform, but needs to be one value.
    LABEL "Number of Sightings"

SVL should throw an error if the query that generates the number has more than one value.

timothyrenner commented 4 years ago

Plotly thinks of everything - https://plot.ly/javascript/indicator/

timothyrenner commented 4 years ago

It probably needs something to denote the value name, so it would probably look something like this:

NUMBER bigfoot
    VALUE report_id COUNT
    LABEL "Number of Sightings"
timothyrenner commented 4 years ago

[x] Add syntax support for NUMBER "plot" [x] Wire number into sqlite [ ] Implement sqlite -> plotly adapter for traces