Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Direct Query - Multiple sorting in 100% stacked bar chart by Akvelon 1.2.3

Hi,   I have a visual like the below using Direct Query and would like to do custom sorting by different variables simultaneously.     1. Sort by TIMESTAMP in decending order (ie. 5/jun, 4...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Icey  Yes I did exactly the same as what you mentioned below but the sorting still didn't work -> I put the [Description] from the below table (with Sort By Sequence Id) into the chart axis and I did not use the [Description] from the fact table, so ideally the chart sorting should follow the sequence according to the Sequence Id but unfortunately it did not 100% follow to the desired sequence.

 

Best regards,

Emily

Icey's avatar
Icey
Community Support
6 years ago

Hi Anonymous ,

 

So weird. It works well on my side.

Can it work in other charts?

 

 

Best Regards,

Icey

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Icey  I haven't test for other visuals because I really need to use this plug-in one as it suits our needs with multiple variables.

    Do you mind to share your testing file with proper sortings for both of the Timestamp and Description?

    Thanks!

     

    Best regards,

    Emily

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Icey  Sorry that I can't open your file as it needs SQL Server credentials for your DB.....

        Are you able to upload sample static data for the Sales table with Import mode?

        Thanks!

        Best regards,

        Emily