How can I display data with zero instances in charts and pivots? In other words, I need to display "0" in a pivot and a label but no bar in a bar chart.
For example, lets say I query a table with animals and their respective calls. A "cats that bark" query has no instances. I want a "0" at the cat-bark intersection in a pivot and a "cat" label on the x-axis of a bar chart.
I'm using Brio Explorer. Is there a way to manually change the charts/pivots? Someone suggested using 'DECODE' in the SQL (e.g., DECODE(animal_type,'cats',1,0)), but the number of values isn't quite limited enough to pull it off.
I'm not afraid to get my hands dirty; I just need someone to point me in the right direction.
Thanks.
For example, lets say I query a table with animals and their respective calls. A "cats that bark" query has no instances. I want a "0" at the cat-bark intersection in a pivot and a "cat" label on the x-axis of a bar chart.
I'm using Brio Explorer. Is there a way to manually change the charts/pivots? Someone suggested using 'DECODE' in the SQL (e.g., DECODE(animal_type,'cats',1,0)), but the number of values isn't quite limited enough to pull it off.
I'm not afraid to get my hands dirty; I just need someone to point me in the right direction.
Thanks.