How to add the % to Top X narritive

Question & Answer
, , , , ,
1

Hi Team,

I am using insight narritives to get the top 3 revenue by products. How can I also add the %?

image
image1359×469 20.5 KB
I can’t add info or calculations after that

Thanks,
Cindy

2

Hello @Cindy

Customize the narrative to format the percentage as needed, such as showing it with a “%” sign and rounding to two decimal places if necessary.

This will allow you to display both the top 3 products by revenue and their corresponding percentage of the total revenue in your Insight Narrative.

3

Thanks for your reply. But I am having difficulties adding the % to the current insight visual. The top x computions only have the value but not % among total like the screenshot I provoded above. can you please help? I can’t add anything to the highlighted part

image
image1408×412 21.7 KB

4

Hi @Cindy

You can easily add the % sign to the current insight by selecting the end of the edit narrative text box, pressing the left arrow twice to move to the end of the previous line, and then adding the % sign.

QuickSight

5

Thanks for your reply. Sry if my previous question is not clear. I want to add the % value not just the simbel “%”.
Like: "Top 3 revenue customers are:
$100 X customer, 10% of total revenue.

Can you please help?

6

Hi @Cindy

Thanks for explaining in detail.

Please create a calculated field to get percentage values, which you can then use in a custom narrative insight. Additionally, you can use level-aware calculations. The following documentation and blogs provide examples that should help you build your calculations.

Example: (syntax may vary)

percentOfTotal
(
     sum(Sales), 
     [Customer]
)