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
chart x axis custom sorting (sorting by another column in dataset)
Migrateduser
<p>Hi,</p>
<p> </p>
<p>I have a chart in which I have months on x axis and measure on y axis and years as grouping.</p>
<p> </p>
<p>In the Category(x series), I selected months abbreviation and in the sort, I selected month number. However, the chart is still not sorting according to month number</p>
<p> </p>
<p>Basically, I have joined the months of my data with the months from calendar to show all months on x axis even if there is null data. I have two questions here</p>
<p> </p>
<p>1) How do I hide the null from grouping? The nulls have appeared in the grouping/legend because I have brought months from calendar and there is no data for them. I want to hide those nulls from chart but still show the months on the x axis</p>
<p> </p>
<p>2) What is wrong with my sorting. Please have a look at the attached images below</p>
<p> </p>
<p>Arif</p>
<p> </p>
Find more posts tagged with
Comments
There are no comments yet