BIP Publisher Layout Template Custom Sorting in Bar Graph — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BIP Publisher Layout Template Custom Sorting in Bar Graph

Received Response
82
Views
1
Comments

Summary

BIP Publisher Layout Template Custom Sorting in Bar Graph

Content

Guys,

Does anyone has idea of how to do custom sorting in BIP Publisher layout template Bar Graph? Currently it is either doing Asc or Desc alphabetically. But according to my requirement I want to sort according to business requirement.

In my DM SQL I added sort order column according to requirement? But only if I use Data Table option I see data is sorted as per SQL output. But when I use Bar Graph it is sorting alphabetically. I don't want to use sort column in report. As the data is coming as 1-xxxx, 2-xxxxx in labels and Legend.

Ex: Month has to sort Jan, Feb, Mar, not alphabetically or 1-Jan, 2-Feb etc.

Did anyone face this issues? If yes please let me know how you resolved it.

BIP : Oracle BI Publisher 12.2.1.2.0

DB: MySQL

Thanks

Answers