Here is datalines code to generate data similar to what I have:
data bugs; input issue_type $ product $ component $ assignee $14. status $ priority $ N; datalines; BUG product1 UI assignee_name1 open high 5 BUG product2 UI assignee_name3 open low 6 BUG product1 UI assignee_name1 closed high 9 BUG product1 docs assignee_name2 closed low 3 BUG product1 docs assignee_name2 open high 5 BUG product2 server assignee_name1 open low 6 BUG product2 server assignee_name3 closed high 9 BUG product1 server assignee_name1 closed low 13 FEATURE product2 UI assignee_name2 open high 6 FEATURE product1 UI assignee_name2 open low 7 FEATURE product2 docs assignee_name3 closed high 11 FEATURE product1 docs assignee_name1 closed low 5 FEATURE product1 server assignee_name1 open high 7 FEATURE product2 docs assignee_name2 open low 4 FEATURE product2 docs assignee_name3 closed high 9 FEATURE product1 server assignee_name3 closed low 16 OTHER product2 UI assignee_name2 open high 8 OTHER product1 UI assignee_name2 open low 6 OTHER product2 docs assignee_name3 closed high 9 OTHER product1 docs assignee_name1 closed low 13 OTHER product1 server assignee_name1 open high 5 OTHER product2 docs assignee_name2 open low 8 OTHER product2 docs assignee_name3 closed high 14 OTHER product1 server assignee_name3 closed low 7 ; run;
We currently have the JSON to create a 2D report for the number of bugs, say assigne by status. Now, we need a JSON to generate a 3D report, say product by assigne by status. This report should have a table of assigne by status for each distinct value of product. How do I generate a JSON file which can have such a hierarchy?
... View more