nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Need help on why my data has mutiple rows and how to work around it

User_0E6OZ

I am a supplier registration request analysis and have created a measure colomn for the number of pending approval request. However, there a mutiple rows for the mesaure for a single request number. can you guie how to change this so there is one row for each request number

Find more posts tagged with

Accepted answers

All comments

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/27858/need-help-on-why-my-data-has-mutiple-rows-and-how-to-work-around-it

Hi @User_0E6OZ,

Welcome to the Oracle Analytics Community!

Could you please share more information, such as a screenshot of the issue (without sensitive data), a brief explanation of the problem, and the report catalog or XML?

This will help us better understand the issue and identify a possible resolution.

Thank you.

User_0E6OZ

Please see screenshot of the table

Screenshot 2026-01-13 161500.png (1539×313)

User_0E6OZ

the request number 1681020, has two rows in the # pending approval coloumn. I want there to be one row in the #pending approval colomn per request number

@Bhaskar Konar Can you please help guide? The screenshot to the tbale is

Screenshot 2026-01-13 161500.png (1539×313)

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/73678#Comment_73678

Hi @User_0E6OZ,

Thanks for the details.

Looking at the screenshot, it seems there are 2 'Category Name' for Request Number: 1681020, as result 2 rows are coming.

If you take out the column 'Category Name' from the report, the Request Number: 1681020 should return only 1 row.

Hope this help.

Thank you.

User_0E6OZ

Thank you @Bhaskar Konar it work if i remove that column.

But what if i dont want to remove the column category name. How to resolve it then? I want to create a graph for the supplier per category as well.

Bhaskar Konar

Hi @User_0E6OZ,

That's good news.

Quick Question for you: Is it possible functionally: for a particular Request Number (1681020) can be associated with 2 different Categories? Wanted to make sure the data are correct.

User_0E6OZ

Yes thats is correct. A request number can be associated with multiple categories.

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/73683#Comment_73683

Thank you! That's good news.

If you present it via graph what issue are you getting?

User_0E6OZ

I havent done a grpah yet. But the issue i am facing is that i want to count the number of pending approvals against a requst number and put it in a performance tile. Since some requests have more than 1 pending approvals, the request is counted multiple times instead of just one.

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/73685#Comment_73685

Hi @User_0E6OZ,

Thanks for the details.

You can develop a report having Request Number and the measure; it will give you the correct number which can be used for the Performance Tiles.

You can do another report where you choose the additional fields like Category Name etc. and the show the results as a graph.

Hope this help.

Thank you.