Forum Stats

  • 3,770,705 Users
  • 2,253,155 Discussions
  • 7,875,553 Comments

Discussions

Obiee Graph

Steelbird
Steelbird Member Posts: 33 Red Ribbon

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:
Steelbird

Best Answer

Answers

  • Christian Berg-0racle
    Christian Berg-0racle Everything Analytics And Data Member Posts: 9,463 Gold Crown
    edited Jul 15, 2020 11:26AM

    Create a time hierarchy on top of your date.

  • Steelbird
    Steelbird Member Posts: 33 Red Ribbon
    edited Jul 15, 2020 11:32AM

    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 Everything Analytics And Data Member Posts: 9,463 Gold Crown
    edited Jul 15, 2020 11:41AM

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

    pastedImage_0.png

    The granularity is day but I just display quarter

  • Steelbird
    Steelbird Member Posts: 33 Red Ribbon
    edited Jul 15, 2020 11:52AM

    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 Everything Analytics And Data Member Posts: 9,463 Gold Crown
    edited Jul 15, 2020 12:00PM Accepted Answer

    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

    Steelbird
  • Gianni Ceresa
    Gianni Ceresa Managing Director | Oracle ACE Director Member Posts: 6,351 Gold Crown
    edited Jul 15, 2020 1:03PM

    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 Member Posts: 33 Red Ribbon
    edited Jul 16, 2020 11:34PM