Sorting of Primary X Axis Argument Values
Hi all,
I have a stacked bar chart. The argument (X axis) is a calculated field that takes a date value and converts to string using the IsJanuary, IsFebruary, etc function. I've also tried using a numeric value using the GetMonth function. Either way, the months show up on the X axis in order except for July. I've tried adjusting every setting that I can think of without finding one that resolves this behavior. Has anyone ever experienced something similar? What setting controls this behavior? Any suggestions?
Iif(IsJanuary([incident_date]), 'Jan',
IsFebruary([incident_date]), 'Feb',
IsMarch([incident_date]), 'Mar',
IsApril([incident_date]), 'Apr',
IsMay([incident_date]), 'May',
IsJune([incident_date]), 'Jun',
IsJuly([incident_date]), 'Jul',
IsAugust([incident_date]), 'Aug',
IsSeptember([incident_date]), 'Sep',
IsOctober([incident_date]), 'Oct',
IsNovember([incident_date]), 'Nov',
IsDecember([incident_date]), 'Dec',
'')
ToInt(GetMonth([incident_date]))
Thanks!
Peter
-
Hi Peter,
I'm not entirely sure why July is showing up at the end of your chart, but I think the order that they are displaying might also just be a coincidence. I think it might be based on the order that the features were queried in your dataset.
A few different approaches that you could try:
- Set the Argument of your series to a DateTime object and use the Date Time Summary Options to sort by month. The one caveat is that if your data spans over multiple years then this will group the data by year/month.
2. This might be a bit more involved, but you could create basically 3 (# of series) * 12 (# of months) series (36 series) and use the Filter String to provide an expression to only show data for a particular month. Here is an example with a few dates. The nice thing about this approach is that you have full control over the order of the series. 
0 -
Hi Patrick,
Thanks for your response. These approaches aren't quite getting to where I'd like with the charting function and am still getting strange sorting behavior for argument series objects. You mentioned that this could be due to the order in which the features are being queried in the dataset. I haven't been able to figure out where I can investigate and/or control this order. Do you have any suggestions for changing this order? I think that must be the case because the order in which the argument values appear in the chart seem to make no sense.
Thanks again!
0 -
Hi Peter,
If you select the Detail band in your report template and then navigate to the properties of it, you can configure certain fields to sort the dataset. If you can sort the dataset based on the field used in your argument (Q1, Q2 etc) then that may help.
0 -
Hi Patrick,
I tried using the Sort By property with my argument value, but this did not have an affect on the sorting of the X-axis values in my stacked bar chart.
Based upon your suggestion, I also set the Series Points Sorting Key in the Chart Designer for each series in my chart to use the Argument value. However, that setting did not stick after saving the report and re-opening it in Designer. This was tried again in Incognito Mode and appeared to be working initially, but after further testing, this setting change did not stick in Incognito Mode either.
I tried then tried changing this for reports in our test and dev environments and found the same behavior. The Series Points Sorting Key setting does not stick after saving.
Can you think of any reasons why Reporting might not commit this change?
Thanks,
Peter
0
Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.
Kommentare
4 Kommentare