Data visualization in required format

Rajneesh S-Oracle

Hello Experts,

May I discuss my one requirement and possible solution related to Data Visualization at OAD:

I am able to create graph like below:

However my requirement is to achieve above highlighted (red colored rectangle) like below:

meaning of each colored block is mentioned.

My data in file is like below:

so basically Data is like:

Number of people =count(Display name)

and same thing I want to display in my bar chart in Y axix.

I tried hard and could show knowledge level as sum of all knowledge levels for all display name as highlighted (red colored rectangle) in above.

Kindly advise me if this can be achieved?

Thanks,

Gianni Ceresa

Hi,

Just to make sure I understand what you are asking: you would like to have a stacked bar chart instead of your current bar chart?

So the "single" bar with a value of 12 should instead be a stacked bar for the 4 values of "knowledge level" and the values 2, 2, 5, 3 for a total of 12?

Rajneesh S-Oracle

https://community.oracle.com/tech/apps-infra/discussion/comment/16811268#Comment_16811268

Hi Gianni, Yes you are correct.

My problem is resolved now:

what I had to do is , make knowledge level data type from number to text, set aggregation to none and treat as attribute (earlier it was measure).

Thanks,

Gianni Ceresa

In theory you shouldn't need to convert to text, but making it an attribute yes (you do this at the dataset definition level). Be default in every dataset every number is marked as a measure. You have to change the type of column for all the numbers that aren't measures (like year numbers etc. )