Skip to content

Data order gets lost with unpivoting #62

@mkfreeman

Description

@mkfreeman

In this examle, the x order gets lost in the pivot to support multiple y columns:

new DuckPlot(ddb)
  .query(
    "SELECT *, monthname(date) as month, month(date) as monthNum from weather ORDER BY monthNum"
  )
  .table("weather")
  .x("month")
  .y(["temp_min", "temp_max"]) // two columns breaks the x order
  .fy("location")
  .options({
    width
  })
  .mark("line")
  .render()

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions