Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Sorting Stacked Chart on Value not used in Chart ,but in dataset
Migrateduser
<p>Hey guys, I'm having an issue trying to sort on the x-axis for a chart based on a value that isn't being displayed on the chart. I'm using 3.7.2 and my dataset is returning the values in order of how I would expect to see them. For my chart I have a sort on my optional Y series grouping, which is necessary because I need the stacks to appear in a certain order. That sorting is fine. For my x-axis, I am plotting a column called <strong>Days </strong>(Monday, Tuesday, etc) and I am trying to get those sorted in order. In my dataset, I have another column called <strong>Day#</strong>, which gives each day a value which I would ideally sort on. The problem I am facing is that my x-axis sort is restricted to what my x series is, so I don't even have the ability to sort on the <strong>Day#. </strong> I tried using the <strong>Day#</strong> as the x series and replacing the strings, but since I'm taking a group average it gives me errors. I figure I'd be able to put in some kind of script but I'm not versed enough to know exactly which piece I'm going after. Any kind of direction would be greatly appreciated, I searched through a few other forum posts but nothing really stood out to me as a solution I can use.</p><p> </p><p>
Find more posts tagged with
Comments
There are no comments yet