Question

Lobby bar chart is not in correct order

T
Rank
Userlevel 2
Badge +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

N
Rank
Userlevel 7
Badge +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.

- Nalaka -
C
Rank
Userlevel 2
Badge +2

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

 

R
Rank
Userlevel 2
Badge +5

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


Terms & ConditionsCookie settings