OBIEE Pivot Graph requirement

Question

Hi

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

asim cholas · Answer

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

DB_Home · Answer

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.

Robert Angel · Answer

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