Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I'm trying to create a bar graph and that shows the most mentioned item for each week by counting its logs.
I cant seem to get the expression correct. I use mode to determine the most occurred item and run the graph by week, but the graph just shows the most occurred item for this week and a graph of its occurrences across the weeks.
MostOccuredItem = mode({$<Item = {*} -{'Unknown'}<} Item)
count({<Item = {'$(MostOccuredItem)'}>} LogNo}
Hi Alexander,
I don't quite understand what you're looking to present on your bar chart. Are you looking to present the most mentioned item for each week in a table like this?
Week mode(Item)
1 ItemA
2 ItemB
3 ItemC
4 ItemA