|# of Release Management Tickets|
I have a column which contains, ticketstatus. Open, Closed, Accepted, In pgress, Resolved etc. I am filtering only open and closed tickets as per requirement.
I have Month(open_time) on my column shelf and countr(number_of_tickets) on rwo shelf.
1. I need open and closed as side by side bars , not the stacked bars. ( have placed tcikets_status col on color shelf)
2. I need to calculate % adherence . Means , Count(closed_tickets)/count(open_tickets)*100.
Please let me know how to achieve this as i m new to tableau and trying to figure out.
Thnks in advance.
Very difficult to answer without seeing your data structure. Can you post a tbwx (save as), with mocked up data if it's sensitive. Maybe a sketch of the chart you want would help as well.