• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 244
  • Last Modified:

Sort the chart based on a field not there in the Chart

This is my sample data on which i am trying to create a graph
Field A                      Field B (Count)                     Field C(Order)
Answer1                      4                                           0
Answer2                      1                                           1
Answer3                      3                                           2
Answer4                      5                                           3

I have used a chart which displays Count(Field B ) on Y axis on Change of Field A on X Axis.
Right now i am able to sort the chart based on Field B.

Is it possible to sort the chart based on Field C?
I want to display the order of the count, same order as the Field C
0
vvuppuluri
Asked:
vvuppuluri
1 Solution
 
Dan WeingartAuthor / CRChartCommented:
If all else fails,  you could likely do this with our CRChart add-in.  Use the @SORT with value of 8 or 9 to key off the first series, then use @IS to hide the key series from showing up in the graph.

-Dan

DISCLAIMER: I work for the company, threedgraphics.com, that makes this product. This product costs money.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now