malloy icon indicating copy to clipboard operation
malloy copied to clipboard

line_chart requires `top` to return almost anything

Open vitiral opened this issue 1 year ago • 0 comments

What happens?

http://github.com/vitiral/malloy-groundhog.git

My guess is that it auto-limits the number of data points on queries. The limit should be raised considerably for graphs/etc IMO.

Without top

image

With top

image

To Reproduce

Code:

# line_chart
run: GroundhogPredictions -> {
  join_one: Prophecy5 with state
  where: Prophecy5.state != null
  group_by: `year` is `day`.year -- groundhog day
  aggregate: prophetic_wisdom is sum(prophetic_wisdom)
  group_by: state
  top: 1000 /* <------- */
}

OS:

gLinux

Malloy Client:

local VSCode

Malloy Client Version:

latest extension

Database Connection:

DuckDB

vitiral avatar Aug 12 '23 23:08 vitiral