Bar chart for data exploration purpose

A Anand Singh

I have a table (not a data warehouse fact or dimension but I can joined it with another table so as to take it till presentation layer in the RPD) with multiple columns say ssn, age, occupation, salary, number of dependents and person having credit card flag. So 6 column in all and the credit card flag actually classifies the record into whether the person is having card or not.

I want to show this data in bar chart with following detail:

- I will ignore ssn completely for this bar chart.

- want to show rest of the four columns as bar chart , one chart for one column of the table. Point here is some of the columns are continuous (numeric type) and some are categorical ( char type). If it is continuous, the x axis to be automatically binned (divided into slab) for numerical columns like age, salary and dependents and y axis to be stacked based on group by credit card flag Yes or No.So the stack can show me total Yes and Total No stacked for that bin. For categorical, for each category on x axis with group by count on Y axis for having credit card flag as Yes or No in stacked bar.

- Also, can I add event on the table in some way so that user selects column name and the respective chart is shown?

- Does OBIEE support automatic binning?

Please suggest if it is possible (Using 11g).

If this is possible, I can extend this for calculating skewness (of the continuous variable type column) and showing fine bar chart bell curve distribution.

Many Thanks

cesar.advincula.o

Hello,

1- I will ignore ssn completely for this bar chart.

2- "want to show rest of the four columns as bar chart , one chart for one column of the table. Point here is some of the columns are continuous (numeric type) and some are categorical ( char type). If it is continuous, the x axis to be automatically binned (divided into slab) for numerical columns like age, salary and dependents and y axis to be stacked based on group by credit card flag Yes or No.So the stack can show me total Yes and Total No stacked for that bin. For categorical, for each category on x axis with group by count on Y axis for having credit card flag as Yes or No in stacked bar."

You could do it, you could create agreggate more bar chart with this option

3- Yes you could create an action link by column an when you clic in one of them you could go to the bar chart that you create

    

4- Does OBIEE support automatic binning?

dont understand what does it mean.

Kind Regards,