I have some retirement data. Some employees are eligible to retire and are coded as such, NOW, OPTNL, or RD MI. I have a column that identifies if the employee can retire under any of these three conditions at three time points: Now, 1 Year from now, and 3 Years from now. I wanted to compare these figures for each program area we have. Our program areas are akin to a department in a company. It is supposed to replace a graphic initially created in Excel.
I put the COUNT for NOW and 3 YEARS in the VALUES section and the program area (DAS) in the AXIS section. But my graph shows the same numbers for both. I feel like I’m missing something.