Insight to comparison on a metric

Hi , I have got the below data . I want to add an insight that compares the direct channel rate to an industry benchmark 22%.

So if my direct return rate is 30%, I want an insight that says ‘the direct channel is x% higher than 22% ‘ . how can i do that ?

Hi @liya101 ,

I would strongly recommend checking out these two resources regarding insight narratives:

Use the narrative expression editor - Amazon Quick

Creating Dynamic Content with Custom Narratives: 2024 Amazon QuickSight Learning Series

One is an article and the other is a video that breaks down creating the visual step-by-step. Both do a good job explaining how to create this particular visual and how to use the narrative expression editor. Check these out and let me know if you have any further questions!

Quicksight but only allows few computations . I have made a dashboard in arena Insight Comparison .

Here i have the conversion rate as 1.2%. I want an insight which says.

Conversion rate is -.95% higher/lower than Benchmark. ( depending on the +ve /-ve sign)

Hi @liya101 ,

Thank you for sending over the Arena link. I went through it and I think I created a solution to your scenario. Refer to the screenshot below on how I set up the insight narrative:

Was this what you were looking for? Test it out and please let me know if you have any more questions.