Clarity

  • 1.  graph sort descending?

    Posted Apr 25, 2019 01:36 PM

    We have a chart portlet that I need to sort DESCENDING. But the only option asks for Sort Column. Any ideas how to achieve this? 

     

    Thanks!

    Vivian



  • 2.  Re: graph sort descending?
    Best Answer

    Posted Apr 26, 2019 04:09 AM

    Depends on the type of chart portlet and the data-provider you are using to drive it.

    But there are separate options on each axis definition for those with 2 axis for example (column, barcharts) - you have to select the different axis on the options drop down to set these and one of the options is "Reverse".



  • 3.  Re: graph sort descending?

    Posted Apr 28, 2019 03:23 AM

    If your source data is from a NSQL query, you may be able to sort the data descending there using ORDER BY in the NSQL.  I've done this a couple of times, in particular, if there are two columns I want to sort by.

     

    Otherwise, agree with David's suggestion of using 'Reverse' - it just depends on what type of Graph you are using.