Use the Narrative view to add one or more paragraphs of text to appear with the results. Narrative text is useful for providing information such as context, explanatory text, or extended descriptions.
Let us take an example to create a narrative view to display top 10 sales by country.
Create a report with two columns country_name and sales_revenue. Sum the sales revenue to get the summarized view of sales by country.
In the compound layout, click on add view and select Narrative as shown below.
Provide the below information in the narrative view
Prefix: specify the header note for the view.
Narrative: Use the format @n to reference a column, where n represents its position of the column in the query criteria. @1 is country name and @2 is the sales revenue.
Prefix: specify footer note for the view.
Rows to display: specify the number of rows to display. Here I have taken 10 to display top 10 sales.
You can use html code for color and to break the row line.
Save the report and place the report in the dashboard where required
Let us take an example to create a narrative view to display top 10 sales by country.
Create a report with two columns country_name and sales_revenue. Sum the sales revenue to get the summarized view of sales by country.
In the compound layout, click on add view and select Narrative as shown below.
Provide the below information in the narrative view
Prefix: specify the header note for the view.
Narrative: Use the format @n to reference a column, where n represents its position of the column in the query criteria. @1 is country name and @2 is the sales revenue.
Prefix: specify footer note for the view.
Rows to display: specify the number of rows to display. Here I have taken 10 to display top 10 sales.
You can use html code for color and to break the row line.
Save the report and place the report in the dashboard where required
You can create any number of narrative views to provide the summary views on top of the dashboard.
Posts
