Forum Discussion

sprasad's avatar
sprasad
Helper II
7 years ago

Sort By in the Visual

In the graphic visual I want to do a "Sort By" 2 items? Is it possible? Right now I can sort by only one item .
Need Help
PattemManohar's avatar
PattemManohar
Community Champion
7 years ago

sprasad  Try creating a unique key field as a supporting field for sorting, for each combination of fields that you want to sort on. Then, use that new field as your sorting column.

  • sprasad's avatar
    sprasad
    Helper II
    7 years ago

    Explain a bit on how do it?

    Take this example

    DatabaseOperating SystemBrowser
    Oracle 11gWindows 10Chrome
    SQL Server 2016Windows Server 2012Chrome
    SQL Server 2016Windows 10Chrome
    SQL Server 2016Windows 10Safari
    SQL Server 2014Windows 10IE
    Oracle 12cWindows 10Chrome
    PostgresWindows 10IE
    SQL Server 2016Windows 10Chrome
    SQL Server 2016Windows 10Chrome
    SQL Server 2016Windows Server 2016Chrome
    SQL Server 2016Windows 10Safari
    SQL Server 2016Windows 10Chrome
    SQL Server 2016Windows 10Chrome
    SQL Server 2016Windows 10Chrome
    SQL Server 2016Windows 10Chrome
    • v-juanli-msft's avatar
      v-juanli-msft
      Community Support
      7 years ago

      Hi sprasad 

      In this example, do you want the "Database" sorted by "Operating System" and "Browser" as below?

       

      Which visual do you need to sort as your said?

      Which columns do you add in the visual? one column or serveral columns?

       

      Best Regards

      Maggie

      • sprasad's avatar
        sprasad
        Helper II
        7 years ago

        Maggie,

         

        I need to all all the 3 coulumns in the visual and I should do the sorting of Database and Operating system.

        Thanks

        Sudhir