I currently have data that I am developing a business report/viz. The issue I see is that while I can show the total number of ideas submitted per business units - I am having trouble with showing the ideas that do not have values for the business priority. This is because they have not been entered in by the team yet. I want to show the existing values that are entered and also null values.
They are categorized by Primary Business Unit and the grouping for the business priority is 0, 1-12, 13-24 and 24-36.
The business priority is submitted by the business teams in terms of the highest level of priority per idea. I added an Excel doc on the concept I am looking for and the raw data I have as a test/mock.
I have also included the type of viz I would like to see. I understand that Tableau sometimes does not show null values if there is no data to show but I would like to show the 0 in the graph.
Please help, I searched everywhere to find a solution.
