G'Day all,
From what I can tell the bar chart - horizontal setting does not respect sort order.
Attached is a screenshot showing:
SQL query with ORDER statement: we tried both DESC and ASC, but the chart stayed with the same order shown.
The Table view sorts as expected, and the bar chart - simple also sorted fine and reversed when the ORDER was reversed.
Am I missing something or is there a problem?
Thanks,
JB

CommentFileSizeAuthor
forena_sort-order.png85.27 KBboabjohn

Comments

scottrigby’s picture

scottrigby
he/him
Primary language English
Location Brooklyn, NY
commented
Issue summary: View changes
Status: Active » Postponed (maintainer needs more info)

@boabjohn if you implement the Highchart library directly, do you still see the same issue? If so, then this sounds like an issue for the HIghcharts library (they recommend Stack Overflow - see http://www.highcharts.com/support).

boabjohn’s picture

boabjohn commented

Hi Scott thanks for the reply.

Actually I'm not sure how to "implement the Highchart library directly"...though it would be interesting to know.

The only way I know to call the library is via your module. I'm using a developer as I'm not a programmer.

Just recently I asked him to give me a version of our custom module that has the database query already "rendered" (ie it's not a live query anymore) so that we could try to test the speed difference between:
(a) live MySQL query + module output + api call to your module => render chart
vs
(b) same as above but take out the MySQL query

So what you're suggesting is to alter our module again...this time we call in the lbrary directly, bypassing your module?

Actually, we could probably do this online using js.fiddle on the HighCharts demo page...hmmm. Ok: will try and let you know.
Thanks for the pointer!
JB