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.
Hi Evan,
Could you try reporting on the knowledge table (kb_knowledge) rather than (kb_use) - I think that may provide you with the total number of views for one article.
I tried the below - not sure how it would look with multiple version so please do share an example if this works for you, would be keen to know 🙂
Hope that helps
Please mark my answer correct and helpful if this resolves your issue.
Good idea but still have duplicates
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.
