Skip to main content
Question

Lobby bar chart is not in correct order


Forum|alt.badge.img+6

Hi All,

I have design a data source which is already ordered by Month column. After connecting it for the bar chart element it is not ordered by month column. Any help for that is highly appreciated.

 

Thanks.

 

 

 

3 replies

Forum|alt.badge.img+11

Hi @TopDeepaW, in the data source, for the order by section, instead of just ‘3’, try adding ‘3 ASC’

Or you could even try the full column name for the order by like ‘EXTRACT(month FROM account_date) ASC’ - although not sure whether this will cause a performance delay.


Forum|alt.badge.img+3
  • Sidekick (Partner)
  • 8 replies
  • January 27, 2023

Hi @TopDeepaW 

 I had the same problem and have found the following solution. 

IFS can apparently only sort the coloums based on a number.

So to my datasource I have added the date formated as a number 

 

The number column I than used as the “Split Series coloum” which gave the correct sorting.

Note there should not be a check in Use Top-N Options

 


Forum|alt.badge.img+7
  • Sidekick (Partner)
  • 13 replies
  • February 3, 2023
Curann wrote:

Hi @TopDeepaW 

 I had the same problem and have found the following solution. 

IFS can apparently only sort the coloums based on a number.

So to my datasource I have added the date formated as a number 

 

The number column I than used as the “Split Series coloum” which gave the correct sorting.

Note there should not be a check in Use Top-N Options

 

Love it!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings