Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 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
Filter by case when statement
Hi,
I have a requirement to filter the report by Male, Female and All Gender. Male and Female are two distinct values for the column. In the prompt, we need to enable user to choose Male, Female and All Gender. The Prompt then pass the value to the report to show either male, female or all gender.
Any suggestions or guidance would be great. Thank you.
Answers
-
Have Gender as an "is prompted" filter in the analysis and then a dashboard prompt with "Gender" on the page as well. Basic functionality.
0 -
0 -
Thanks, Sorry I should explain more precisely. We explicitly want Male, Female and All Gender as display value in the prompts. the underlying value for gender column is male, female. How to we deal with All Gender option?
0 -
Thanks, Sorry I should explain more precisely. We explicitly want Male, Female and All Gender as display value in the prompts. the underlying value for gender column is male, female. How to we deal with All Gender option?
0 -
Obvious question: Why not correct your data? Why not immediately store *M*ale and *F*emale?
If you don't want to or can't correct your data - why not put that logic into the RPD so that it's actually a coherent logic which gets applied everywhere? I.e. init-cap *M*ale and *F*emale in the logical column.
As far as "All Gender" goes...you are aware that you're woring with an analytical platform and not some random web application where you change labels based on the colour of socks the business guy put on this morning.
Your data is your data. If it's rubbish you'll report on rubbish. If you force a fake "All Gender" just to have that displayed visually rather than using the tool as it was designed and as it works you are literally wasting time and effort on something utterly without added value. Plus next time there is a new member in that attribute column - newsflash: male / female binary option is outdated since a Long time - then you will need to hange all logic. And if you insist on doing things in the front-end you will need to change your logic in every single place you've implemented it.
0 -
It is always better to have the data at backend.
However in this situation , you can achieve it by creating two different reports and creating a condition in section of your dashboard page. Let me know if you need any further help.
in the first report values to be filtered by the prompt values and second report without filter for gender. Create a variable prompt .
0 -
Condition report
0 -
Great workaround! Thanks
0