# of Release Management Tickets | ||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | |
Open | 50 | 52 | ||||||
Closed | 48 | 54 | ||||||
% Adherence | 98% | 99% |
Hi,
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.
Kindly respond.
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.
Become a Viz Whiz on the Forums! Support the Community and master Tableau.