microsoft / microsoft/SandDance

Sorting in Charts doesn't take into account numeric values

Open
#318 5 comments 1 reaction 1 assignee View on GitHub

@danmarshall is already working on this.

Since Jan 5, 2023.

Dominant language
TypeScript
Stars
7.1k
Forks
573
Avg merge
8d 9h
Merged PRs (30d)
4

Description

Tool
Azure Data Studio v.128.0
SandDance: v3.1.0

Problem
I am using a simple select query on a SQL database.

Select Cast(StartHour as int) as StartHour, Cast(Duration as float) as Duration,  Cast(count(Duration) as float) as NumTimesDuration
from dbo.DurationDataset
group by  StartHour ,Duration
order by StartHour , Duration desc

The output produced when visualised sorts the charts using numbers treated as strings.
For instance 1, 2 and 13 is shown as 1, 13, 2

Issue

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.