Report Not Showing All Stacked Columns

[Scott Jordheim]

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.

[Ct111]

I think if your report is not showing correct data then it might be cluttered

PLease read this useful message from SNOW docs I think it might give you clear idea why results are not displayed correctly

Divide each bar using values of this field.

Note: It is not possible to group or stack reports by theTags field.

On a bar chart of incidents sorted by Category and stacked by Priority, a user sees the proportion of high, medium, and low priority issues for each category.

Select stacked fields carefully to avoid cluttering the report. Sometimes it is a better practice to create another report that shows these relationships rather than stack too much data. Bar charts display a legend only when a stacked field is selected. Boolean, reference, and choice lists can be used as stacked fields. Date, date/time, integer, long, string, and text fields cannot be used as stacked fields.

Note: Date types are not allowed starting with the introduction of the Report Charting v2 plugin.

You can choose to display the stacked field either in a single bar or as a group of bars.

If you select a Group by field on the report form, you can choose to visualize the bars as Grouped bars. In this case, bars are displayed next to one another per the Group by field (for example, the state of the incident), instead of stacked.

If you choose fields with Additional group by, these fields are also available in a Stacked by control at the bottom of the report.

Mark my ANSWER as CORRECT and HELPFUL if it helped

[Scott Jordheim]

True. However one would think 3 total options wouldn't be considered cluttered. I could definitely see 10 "stacked by" options causing those issues, but with 3 (and a relatively small amount of users on the X-axis), it shouldn't cause issues.

If need be, this could be done with drilldowns (like what was suggested in your post), but I honestly believe this shouldn't call for that.

[Adam Stout]

Do you get the same results when you use the Report Designer instead of the legacy Report Builder?

[Scott Jordheim]

Correct. Shows the same in each reporting UI version.