How to get total sum value from Insight top 10

Hi Team,

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”

Hi @Li_Yang,

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.

Hi @Li_Yang,

Following up here as it’s been awhile since we last heard from you; did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

Hi @Li_Yang,

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.

Thank you

The ticket can be closed. Thank you for following up on this matter.