Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Transactional Business Intelligence

Unpivot the data

Question

Views

Comments

Julia Kiszelewska1234 Rank 1 - Community Starter

Nov 24, 2023 12:02PM in Oracle Transactional Business Intelligence

Hi,

Is there a way of showing date and hours worked in separate columns per person instead of the way it is on the visual below?

I have tried casting and unpivoting but had no luck.

Help would be much appreciated.

Thanks in advance.