Hard to read column chart about evidence

[hughess]

@yhoiseth my mistake - I realized your query uses count() and is not referencing a column directly. This is a bug in our database connector. I've opened another issue for that here #86. For now, you can cast the result of your aggregations to numeric, but I'm hoping we'll have a fix for the type issue soon.

[hughess]

Thanks for creating an issue! There's definitely something strange going on in that chart. Even with a high volume of data, it should be able to render in a way that is readable. I'll look into this.

Does the same thing happen if you use LineChart? That will help me narrow down the cause of the issue.

We've talked about the ability to use other charting libraries inside Evidence and will be looking into that - thanks for the feedback!

[mcrascal]

Agreed w/ Sean -- adding support for a third party charting library is a super reasonable proposal. I have opened a separate issue to track this here #83

[hughess]

@yhoiseth I replicated the issue and initially thought it was a bug in our y-axis, but it turns out it's caused by numbers stored as strings. If you cast your employee_count column as a number, the charts should work as expected. Let us know if that works!

With a string column, the chart tries to plot every value without creating a scale, which is why there were so many things overlapped on your chart. I'm going to close this, but I've added an issue to show an error in the chart component in the future: #84

[hughess]

@yhoiseth I forgot to reply to your comment about needing interactivity in the charts. This is on the roadmap (and hopefully we can open up the ability to use other charting libraries too), but in the meantime if you hover your mouse over a column on your chart, you'll get a small popup label for that piece of data. Hopefully that will help a bit until we get some real interactivity up and running!