Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 213 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Applying a filter to a COUNT
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:
Best Answer
-
Attached the Calculated item used to get the results let me know if this works for your environment
0
Answers
-
How does that calculation relate to the bottom right viz that you are presumably talking about. How are you counting what precisely?
0 -
The problem that your "CUSTOMER ID" is a dimension and not a Measure so you can try to Use CAST Function with the "CUSTOMER ID" Column to Double and re-Test your equation.
If the source identified CUSTOMER ID As Measure your calculation will work0 -
Thank you for your responses.
@Christian Berg The count, if I was to put it in a sql statement, would be:
SELECT COUNT("CUSTOMER ID") FROM TABLE WHERE "ORDER AMOUNT" =0;
I would expect the result to be 3, but in this case 'No Data Found'.0 -
Thank you @Mostafa Morsy-Oracle
Do you mean something like this:
0 -
@Mirithu - Please share the calculation details currently being used to calculate count of customer ID to validate why it works for one scenario and not for the other one. Thanks.
0 -
@Christian Berg The count, if I was to put it in a sql statement, would be:
SELECT COUNT("CUSTOMER ID") FROM TABLE WHERE "ORDER AMOUNT" =0;
I would expect the result to be 3, but in this case 'No Data Found'.My question was "how are you counting what exactly" and Sumanth also asked you for the calculation details.
I know what the SQL would look like. The question is how are you doing things right now? What you are doing and how you are doing decides what you are seeing. Not some theoretical SQL statement.
0 -
Thank you @Sumanth V -Oracle
Actually, the calculation is simple - Get the number (count) of customers who have an order amount of zero from the given table.If I use a Table visual, I am able to show all customers and their order amounts, and if I apply the filter "ORDER AMOUNT = 0", I can display only the customers with zero order amounts (as in the image provided).
The problem is when I apply this same filter to the count of customers. Using a Tile visual, I can show the count of customers - 10 in this case. But when I apply the the filter ( "ORDER AMOUNT = 0" ) to the Tile visual, it shows "No Data Found", yet I expect it to show 3 as the count.
Here is the data I am using:CUSTOMER ID
ORDER AMOUNT
68602
14,738.00
38327
0.00
68273
14,596.00
31555
13,917.00
21718
0.00
21983
7,357.00
4576
12,186.00
13921
14,985.00
20263
0.00
79018
6,960.00
0 -
0
-
"If I use a Table visual, I am able to show all customers and their order amounts, and if I apply the filter "ORDER AMOUNT = 0", I can display only the customers with zero order amounts (as in the image provided). "=⇒ How are you defining this filter , can you show screenshot? If Order Amount is a measure you can only apply range/topBottomN filter.
Thanks
Gayathri
1 -
I make this works for you please have a look to the following
If this is what you looking for let me know and I will send you the workbook and you can use it in your project
1
