Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Obiee Graph

Received Response
31
Views
7
Comments
Steelbird
Steelbird Rank 4 - Community Specialist
edited August 2024 in Oracle Analytics Cloud and Server

Hi  Team/Jerry Casey, @Gianni Ceresa

The below graph is built based on Date column with two measure columns. The requirement is like On X-axis Instead of Date value We need to display Period value something like start of Period Jan-20,Feb-20.How can we achieve it?

pastedImage_0.png

Thanks,

Steel

Tagged:

Answers

  • Christian Berg-0racle
    Christian Berg-0racle Rank 10 - Analytics Guru

    Create a time hierarchy on top of your date.

  • Steelbird
    Steelbird Rank 4 - Community Specialist

    I want to reiterate the issue @Christian. We already had a time dimension If I added Period the data is summing up and showing as month wise data, But I should show up Graph with date and X-axis Label like period.

  • Christian Berg-0racle
    Christian Berg-0racle Rank 10 - Analytics Guru

    Sorry, my bad, wrong word. s/create/put

    pastedImage_0.png

    The granularity is day but I just display quarter

  • Steelbird
    Steelbird Rank 4 - Community Specialist

    Christian Berg , Is there a way that I can restrict  to display 2013 Q1,  2013 Q2, 2013 Q3, 2013 Q4 only once during the start of the quarter. I also tried the above way but period is displaying multiple times.

  • Christian Berg-0racle
    Christian Berg-0racle Rank 10 - Analytics Guru

    If you want the granularity to be "Date", then the whole graph will be on that level. You can't have both


    Edit: You can colour it though

    pastedImage_1.png

  • Gianni Ceresa
    Gianni Ceresa Mod

    First thing first: this is not a graph, it's a chart (sorry, spending lot of time on Graph Database I'm a bit pedantic on this one )

    I believe Christian gave you what you are after.

    Steelbird wrote:Is there a way that I can restrict to display 2013 Q1, 2013 Q2, 2013 Q3, 2013 Q4 only once during the start of the quarter.

    If you are really after a precise alignment of your quarters exactly at the beginning of the quarter instead of across all the months/weeks/days composing the quarter, it would be trying to cheat and have a column which has a value only at the beginning of the period and has "" the rest of the time, but still using the real detailed column to force the level of the analysis down to that level, and using the made up column as display trying to cheat on it.

  • Steelbird
    Steelbird Rank 4 - Community Specialist

    Christian Berg & @Gianni Ceresa