nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

BIRT Chart - X axis not sorted correctly

niranjan087

<div>I'm getting data back from database and displaying it in BIRT Chart. I am plotting hour in X axis and reading (for that corresponding hour) in Y axis. I want the hour in X axis to be in ascending order like 0,1,2,3,4....23. So , I set the Grouping and Sorting in X Series to Ascending(screenshot attached). But, in the resulting chart ascending order has been applied to hour's first digit and then second digit i.e. it is displaying like 0,1,10,11,12,13....19,2,20,21,22,23,3,4,5...9(Attached the graph screenshot) Please refer to the attached screenshot and suggest me how to arrange the goruping and sorting.. Any help would be greatly appreciated..</div>

Find more posts tagged with

Comments

PaulCooper

This occurs because you are sorting on a string rather than a number. If your X-axis field contains hours and is a string you need to convert the value to a number (a computed column or binding with the expression of parseInt(row["field_name"], 10) should do the job).
 
If it is a DateTime field then you need to set the grouping interval's Type should be "DateTime" and the Units should be "Hours".
 
Paul

niranjan087

Thanks for your reply Paul. I understood the issue. The parsing code you have given parseInt(row["field_name"], 10), i tried putting it in 2 places One in 'Category X Series' and 'Sort on' option in Grouping and sorting. Also I changed the grouping to Numeric . Please refer to the changes made in attached screenshot. But the graph looks weird now showing 'NaN' values in x axis. Please refer to screenshot attached. Where should I do casting or parsing you suggested?

PaulCooper

The second argument to the parseInt function should be 10 not 2. This is the base. 2 would mean binary. You don't techincally need the base number but adding it stops parseInt function thinking number with leading zeros are octal (base 8) so adding this is good practice.
 
Because you put 2 numbers 2 to 9 and 12 to 23 would be converted to NaN.