Oracle Communities

Oracle Analytics and AI

Child Item

How to average for a Radar Chart when using Category in FDI?

I have a dataset which consist of 6 Factors and each factor has 2 questions, the dataset will vary on how many rows for Reviewees E.g. Sometimes there will be 2 team members respond and sometimes there will 6 team members.

I have written a Calculation which is SUM of Response Rating / COUNT of Response Rating (excluding where Reviewee Relationship = Subject)

I am trying to visualize the dataset in a Radar Line chart however, when the chart populates it averages Response Rating as a total for the entire dataset instead of by factor. Note: I have Factor added in Category section within FDI.

Any suggestions on how to overcome this?

Example datasets below:

Find more posts tagged with

FDI

Fusion AI Data Platform

Accepted answers

Scott_Turner_

Hi @Mallikarjuna Kuppauru-Oracle ,

I have reviewed the SQL and it does not seem to group by, even though I have added factors in Category section.

Would this be something I would need to lodge a ticket to get support to better understand?

SQL_Leadership Outcome.txt

Thx

Scott

All comments

Mallikarjuna Kuppauru-Oracle

Hi @Scott_Turner_

Seems to be an Grouping issue . Did you verified the sql query generated from workbook so that you can able to get the clear idea on how the tool is calculating?

Regards,

Arjun

Scott_Turner_

Hi Arjun @Mallikarjuna Kuppauru-Oracle ,

Thank you for your response, unfortunately I am not sure on how verify the SQL from a workbook in Fusion. I agree with you though on the Grouping, as when I select multiple Factors which is how I am grouping (Category) the values increase based on number of factors selected.

Any thoughts on how I could achieve a radar chart given the data set?

Thanks

Scott

Mallikarjuna Kuppauru-Oracle

Hi @Scott_Turner_

You can refer below - ( To verify the sql query)

How To Enable The Developer Option To Analyze Query Performance For A Data Visualization Workbook [Video Content] (Doc ID 2831471.1)

Regards,

Arjun

Scott_Turner_

Hi @Mallikarjuna Kuppauru-Oracle ,

I have reviewed the SQL and it does not seem to group by, even though I have added factors in Category section.

Would this be something I would need to lodge a ticket to get support to better understand?

SQL_Leadership Outcome.txt

Thx

Scott