Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
BIP Publisher Layout Template Custom Sorting in Bar Graph

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
-
Any work around is appreciated, Thank you
0