Oracle Analytics Cloud and Server

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

OBIEE Pivot Graph requirement

Received Response
4
Views
3
Comments
DB_Home
DB_Home Rank 3 - Community Apprentice

Hi

Can we divide(split)/borders attribute values in pivot graph as shown in below graph?

pastedImage_1.png

Answers

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Hi, provided the data group electrical / mechanical / hydraulic exists in your data set, or can be calculated using case / bin logic or whatever then it should just be a case of dragging the field into the columns area, same as the existing switch, plug, cord etc

  • DB_Home
    DB_Home Rank 3 - Community Apprentice

    Hi Robert,

    Thanks!

    Forget about electrical/mechanical/hydraulic...I have data like switch,plug,cord,fuse...etc. Here when I create the Pivot graph it splits the data.

    But I want to split the data with borders as shown in the below graph.

    pastedImage_1.png

  • asim cholas
    asim cholas Rank 6 - Analytics Lead

    Cant you concatenate splitter in to the data set something like below?

    ColumnName||'|'

    and add enough space between splitter if needed.

    Column Name||'       '||'|'

    Thanks

    Aj