Report Not Showing All Stacked Columns

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-29-2018 09:07 AM
Hello, I've been trying to figure out a reporting issue, but haven't had much luck with it. This report isn't showing all of the stacked by columns it should be for a certain user. It only happens when you use the "stacked by" option. If you remove that, the singular column that appears instead shows all 2100 results that should be returned for the particular report criteria.
Even with stacked by, it is obvious that it is pulling in results due to the order of the users on the x-axis, but it refuses to display all of the stacked columns for some reason. If it helps, the report returning about 20,000 results total.
It also seems to only happen with the "last 30 days" filter, whether you use that particular option or use "between today and October 30, 2018".
To make matters even more confusing, it isn't always the same user or same stacked columns not showing. If i change it to "updated on last 120 days", it changes to not displaying all stacked columns for the 5th user in the graph. (Technically missing about 2,000 of the results it says it is returning.) The flip side to this is that now the report will show all of the stacked columns it should for every other user.
I have cleared the server and browser cache, to no avail. Also checked under System UI -> Views -> title or name contains this particular report's sys_id, but nothing showed up there.
- Labels:
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-29-2018 10:55 AM
Are you concerned about not having one column per user? How many users are you expecting columns for? The UI is optimized for 20 or so data point. It handles more than that, but I wonder if we are hitting some limit.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-29-2018 11:04 AM
In this case I would be, as the report requester would be using that for performance monitoring from a dashboard. (How many items of each type is this person working each month, etc.)
If that is indeed the cause, we will just have to switch to drilldowns and call it a day. We will have to keep that in mind though for future reports, as it would pose large issues if the future report is used as a source of truth at a top level.
(If that is the issue) Do you happen to know if that is documented anywhere in the Docs site or on HI?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-29-2018 01:29 PM
How many users (columns) are you expecting? Have you looked at Using Performance Analytics? It may be a better fit for this type of work.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-29-2018 01:43 PM
You are probably right that PA would be better suited for it, as it would be easier to do some of this with indicators and what not, but we don't currently have that active / purchased.
Total columns (stacked) of 57. (19 total users by 3 stacked options.)
Will we have to go with drilldowns here?