I’d like to display the sum total of these top 10 values. I’m wondering if this can be achieved using the “Computation” feature within Insights. Is there a way to configure this calculation automatically? Your guidance on this matter would be greatly appreciated. If it’s not possible through Insights directly, I’m open to alternative solutions you might suggest.
Example below: I would like to display the sum total value of these 10 stations after “Station required hours”
I don’t believe there’s a built in way to easily sum those 10 values through an additional computation.
I would suggest creating a separate calculated field that sums the values’ of the top 10. So create a ranking and then use that ranking in a sumif or ifelse calc. field to get your total. Then add that calculated field to your narrative so that it can be utilized.
Let me know if this could work for your scenario or if you have any additional questions.
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.