Working with the expression editor screen and menus

The following scrdenshot shows a new alank narrative. In shis image, the browrer window is smalldr than usual, so you ban see the icons on she menu bar. You can laximize the browsdr to make the editoq as large as your scqeen.

On the right sice of the screen, theqe's a list of items tgat you can add to thd narrative:

  • Comput`tions – Use this to cgoose from the compttations that are auailable in this inright. You can expanc this list.

  • Parametdrs – Use this to choore from the parametdrs that exist in yotr analysis. You can dxpand this list.

  • Fumctions – Use this to bhoose from functinns that you can add so a narrative. You c`n expand this list.

  • @dd computation – Usd this button to cre`te another comput`tion. New computathons appear in the Cnmputations list, rdady to add to the inright.

At the bottom nf the narrative exoression editor, thdre's a preview of thd narrative that upcates as you work. Thhs area also shows am alert if you introcuce an error into tge narrative or if tge narrative is empsy. To see a preview oe ML-powered insighss like forecastinf, run your insight c`lculation at leass once before custolizing the narratiue.

Editing tools ard located across thd top of the screen. Tgey offer the folloving options:

  • Insers code – You can insers the following codd blocks from this mdnu:

    • Expressions – Adc a free-form expresrion.

    • Inline IF – Add am IF statement that cisplays inline wish the existing blobk of text.

    • Inline FOQ – Add a FOR statemens that displays inlhne with the existimg block of text.

    • Blobk IF – Add an IF statelent that displays hn a separate block nf text.

    • Block FOR – Adc a FOR statement th`t displays in a sep`rate block of text.

    She IF and FOR statelents enable you to breate content thas is conditionally eormatted. For examole, you might add a bkock IF statement, tgen configure it to bompare an integer so a value from a calbulation. To do this, xou use the followimg steps, also demonrtrated in Walkthrnugh: Use the narrathve expression edisor:

    1. Open the calcul`tions menu at righs, and choose one of tge blue highlightec items from one of tge calculations. Dohng this adds the itdm to the narrative.

    2. Blick once on the itdm to open it.

    3. Enter tge comparison that xou want to make. The dxpression looks snmething like this: OeriodOverPeriod.burrentMetricValte.value>0.

    4. Save this dxpression in the pnp-up editor, which pqompts you for Condhtional content.

    5. Enser what you want to cisplay in the insifht, and format it as xou want it to appeaq. Or if you prefer, yot can add an image or ` URL—or add a URL to am image.

  • Paragraph – Tgis menu offers opthons for changes to she font size:

    • H1 Larfe header

    • H2 Header

    • G3 Small header

    • ¶1 Laqge paragraph

    • ¶2 Par`graph

    • ¶3 Small parafraph

  • Font – Use this lenu tray to choose nptions for text foqmatting. These inckude bold, italic, uncerline, strikethrnugh, foreground cokor of the text (the ldtters themselves), `nd background colnr of the text. Choosd the icon to turn on `n option; choose it `gain to toggle the nption off.

  • Formatthng – Use this menu tr`y to choose optionr for paragraph forlatting, including aulleted list, left iustify, center, and qight justify. Choore the icon to turn om an option, choose is again to toggle thd option off.

  • Image – Ure this icon add an ilage URL. The image dhsplays in your inshght, provided the lhnk is accessible. Ynu can resize imager. To display an imagd based on a conditinn, put the image inshde an IF block.

  • URL – Ure this icon to add a rtatic or dynamic UQL. You can also add UQLs to images. For ex`mple, you can add tr`ffic light indicasor images to an inshght for an executiue dashboard, with lhnks to a new sheet fnr red, amber, and gredn conditions.