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

Applying a filter to a COUNT

Mirithu

Hello,
I am new to Data Visualizer and I am using Oracle Analytics Desktop (current version).

I have a simple table with two columns and ten records (see image). I can create a table visual and apply a filter to the table successfully. But when I do a count of the records and apply the same filter, it shows no data. Where am I going wrong?
The image shows the table contents and the filter I am applying:

Find more posts tagged with

Accepted answers

Mostafa Morsy-Oracle

Attached the Calculated item used to get the results let me know if this works for your environment

All comments

[Deleted User]

@Mostafa Morsy-Oracle in order for that screenshot to be valuable to the OP please also include the formula you used for your calculation of "Amount" under "My Calculations".

The confusion in this thread exists because of insufficient details being shared and a solution can only be made clear to any forum user browsing this thread by being precise and clear.

If people have to patch together bits and pieces of information across 10 posts, then the thread does not provide much value to the community at large.

Mostafa Morsy-Oracle

@Christian Berg will provide the formula and all steps once @Mirithu confirm that screen shot meet his expectation because it will be confusing for other users who looking for same to check the formula blindly without confirming the solution from the requester

[Deleted User]

Hello @Mirithu can you please update this thread? Several people have tried to help you and Mostafa has a solution for you.

If you abandon your thread it won't resolve your issue nor will it help other forum users to benefit.

Thanks!

Mirithu

My apologies for my explanation not being clear enough.

Thank you @GayathriAnand-Oracle.

Thank you @Mostafa Morsy-Oracle , your calculation works. Its what I was looking for.

Mostafa Morsy-Oracle

Attached the Calculated item used to get the results let me know if this works for your environment

Mostafa Morsy-Oracle

@Mirithu please check above☝️

Mirithu

Yes @Mostafa Morsy-Oracle, it works perfectly in my case. Thank you.