I have a report where my knowledge base articles numbers repeating putting views separate. I know this is because of newer version are being made, but I need total views for single knowledge base article number. I need it this way because when I send out a scheduled report in PDF or EXCEL I don't need articles repeating.
If I group by -> article -> number (this doesn't do much for me either)
You can try building a bar graph grouped by Number and aggregation is sum of View Count, then select "Display data table" and if you want to hide the bar visualization then set the chart width and height to 0 px.
The report can be based on kb_use grouped by Article.Number and stack by User.Title or User.Department (though not both). The data table will also perform the grouping and stacking.
