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 .

5 Replies

  • PattemManohar's avatar
    PattemManohar
    Community Champion

    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

      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

        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