Skip to main content

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.

 

 

 

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.

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

 

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