- OneStream Community
- Forums
- Reporting
- BI Viewer - Bar Chart Order by Time Dimension
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-21-2023 02:12 PM
Hello,
I'm trying to create a 5 quarter bar chart trend in BI Viewer, but I can't get the time dimension to properly display the columns in the correct time order, it keeps defaulting to alphabetical (ie Q4 2022, Q3 2022, Q2 2023, Q2 2022, Q1 2023). Does anyone know how to fix or adjust for this?
Thank you!
Solved! Go to Solution.
- Labels:
-
BI Viewer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-21-2023 04:27 PM
Are you using a cube view MD data adapter? If so, set Add Start End Calendar Time to True.
Then use these two new fields: EndDate/StartDate in the BI Viewer graph. This will enable more options for you to use such as Month-Year, Quarter-Year, etc when you select how you want to display.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-21-2023 04:27 PM
Are you using a cube view MD data adapter? If so, set Add Start End Calendar Time to True.
Then use these two new fields: EndDate/StartDate in the BI Viewer graph. This will enable more options for you to use such as Month-Year, Quarter-Year, etc when you select how you want to display.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-21-2023 04:31 PM
Thank you so much! That did it!
- Dimension setup to meet different needs in Application Build
- Display text field or other Member Filter in BI Viewer dashboard for dimensions in Reporting
- Create CSV with Parent/Child relationships across Extended Dimensions in Rules
- Member List Business Rule in Data Access Security in Application Build
- How to add two dimension (UD2s) hierarchy in same row/column in cube view? in Reporting
