Cognos Analytics

Expand all | Collapse all

Sorting Numbers in Visualisation categories

  • 1.  Sorting Numbers in Visualisation categories

    Posted 21 days ago
      |   view attached
    Hello, I've been trying to sort numbers in the x-axis of visualisation without success.  I'm not sure if this is a bug or I'm missing a setting.  I sort the numbers in ascending order which should go from -32 to 0, but the x-axis shows -1,-10,-11,-12,...,-9,0.  When using charts there's no issue at all. This seems to be related to visualisations in reporting and dashboards.
    Anyone knows the setting to fix this or if this is a known bug ?

    ------------------------------
    Mauro Santos Otero
    ------------------------------


  • 2.  RE: Sorting Numbers in Visualisation categories

    Posted 21 days ago
    Hello Mauro,
    In cases where the automatic sorting is not performing as expected I create a new data-item in the relevant query only for the sorting and use that data-item for sorting in the visualization. I'm not sure which visualization you are using, but in the traditional charts there is the option of sorting according to a different data-item than the one shown in the visualization.
    Hope that helps,
    Ori


    ------------------------------
    Ori
    ------------------------------



  • 3.  RE: Sorting Numbers in Visualisation categories

    Posted 21 days ago
    Edited by Mauro Santos Otero 21 days ago
    Visualisations cannot be sorted using a different data item. In this case, I need the numbers to be sorted in ascending order, but the output is shown in the attachment.
    Anyway, I have created a new data item with the original month relative value and now the numbers are sorted properly. Many thanks for the workaround !!

    ------------------------------
    Mauro Santos Otero
    ------------------------------


  • 4.  RE: Sorting Numbers in Visualisation categories

    Posted 21 days ago
    You're very welcome. Glad it worked.
    The visualizations that allow sorting by a different data-items are in the "Charts" category (underneath "Legacy visualizations"). If you use for example the "Clustered Line" visualization then you can sort your x-axis according to a different data-item of your choice.

    ------------------------------
    Ori
    ------------------------------



  • 5.  RE: Sorting Numbers in Visualisation categories

    Posted 21 days ago
    I think it worked because there were numbers and I didn't sort them. As soon as I try to sort them in ascending and descending order, it doesn't work.
    The charts are working fine. I found the issue with the 11.1 visualisations.  I still think it's a bug, and when using dashboards, legacy charts are not available.

    ------------------------------
    Mauro Santos Otero
    ------------------------------



  • 6.  RE: Sorting Numbers in Visualisation categories

    Posted 20 days ago

    Mauro Santos Otero – a couple of things to look into:

    -       Ensure that the field that populates the x-axis is a numeric data type and not a character datatype

    -       You could also perform a manual sort on the x-axis values, but not ideal if there are too many values or when new values are added to the data

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Peter Chan

    613-295--0428