Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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
91
Views
1
Comments
ts001
ts001 Rank 2 - Community Beginner
in Oracle Analytics Forum

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