Hi. I am working on a dashboard and want to give users a tile that shows a category with the highest value. To be a bit more clear, users log expenses and tie them to a set of categories (stored as an option set) and I’d like this dashboard tile to display the name of the category where the majority of expenses are going. This would mean totalling up each item’s cost, sorting by category and identifying which category has the highest number. My math and programming skills are not good enough for this.
Does anyone have an idea as to how I might go about this? Thanks.
This is all in a text element, but you could put it on a RG and instead of showing the first item, you can show the list ranked by their sums (or maybe even stick it on a chart)
Also I made Category as a datatype cause I figured users would want to add their own Categories, but it should work the same as an option set (but Category’s Name might be Display instead).
I was making an example at the same time, and it is literally the same as Tyler’s, but with the option set instead. So, great minds… or something like that.
