Hi Mike.
Sounds like you're trying to do multiple stack bars per time period. I have been hunting this one this week also. In Jakarta, this is a straightforward process that does not require special licensing as far as I can tell. Before that, you have to have Performance Analytics Premium subscription.
The feature you are looking for is called 'multiple data sets' which you can find in the docs site.
The procedure is basically this:
- Create your report with the filter showing just one group's data, stacked the way you like it, with the time periods you like, etc. Save it.
- Up in the Save drilldown menu in Istanbul, there's an entry for Multiple Data Sets. If you haven't got PA premium it'll toss you an error about it.
- If you do have PA premium then you can proceed with the steps described in the docs. A teammate of mine said she's been able to show up to 5 datasets at a time.
In Jakarta there's a new Report Designer interface. In that, you have to find the button at the top right that looks kinda like a flowchart, under the Run button.
The hover tip says 'Show Report Structure'. When you click it, you get a flyout menu with buttons to let you add a drilldown or a dataset. You want another data set. When you click it, everything blanks out and you have to define your second dataset as if it were a brand new report of its own. So use identical queries and settings and tables and whatnot (different color settings are helpful), but set the report name to the name of your group. The save button there says 'Save Dataset' and it takes you back to the main report with your new data inserted alongside the original data. If you do this three times for three different groups, you get something like this (mine is a resource allocation report instead of something about incidents, but the look of the thing proves what's possible.
In my case, the orange stack is the 'Analyst' group, the blue stack is the 'Database' group, and the green stack is the 'Software' group. The stacks themselves are a 'category' field with values Availability and Project Confirmed. Everything is summing the data from the underlying table (person days), and on two of the three data sets the sums are showing (data labels turned on).
The important part is that all three data sets (the original report plus the two added data sets) have to be nearly identical in their major settings. The differences in mine is only the report filter specifying which group. My legend labels are gross because I was not sure how the 'report name' of the data sets would play together.
This screenshot is from Jakarta. I have not attempted to reproduce in Istanbul because I haven't got an instance with PA on it. I also am not sure if this is possible in Helsinki using PA.
Hopefully this helps someone.
Kristina
Hi Kristina,
I just read your post on this and was wondering if there is a way to pull the same type of multi-data set data with multiple tables. If so, how would I go about creating a view that I can put on a dashboard, but it is in one widget? I guess I could do the Process Widget, but that is still multiple views... I did the attached reports for SLA Definition in Kingston, I was hoping that I could throw in an Incident count as well as the Time Worked, but I haven't figured it out yet.
Regards,
Daniel Woods
