Skip to main content

Creating Markdown with AI

You can use the Query Helper to generate markdown visualizations based on natural language prompts. The AI will create rich, flexible data displays that combine HTML, CSS, Mustache template variables, and custom Omni components like <Sparkline> and <ChangeArrow>. To create a Markdown visualization with AI:
1
Create a query in a workbook.
2
Open the Query Helper.
3
Ask Blobby to create a custom layout (e.g., “Create a custom HTML layout for this data” or “Show this as a formatted text display with sparklines”)
4
Review and refine the generated Markdown visualization as needed.
Once generated, you can continue to refine the visualization through the chat or manually edit it using the Markdown editor. To learn more about building visualizations with AI, refer to Generating visualizations with AI.

Using the Markdown editor

When you select Markdown as the visualization type, a Markdown editor will display in the chart’s Options pane. As changes are made, the chart area will automatically update. At the top of the editor is a toolbar to help you generate correct Markdown syntax for common formatting actions. The Markdown editor in the Options pane with a formatting toolbar at the top You can also access the Markdown editor in a draft dashboard by clicking the icon on a Markdown tile and selecting Edit in chart. The tile will update as you make changes in the editor. Editing a Markdown tile from a draft dashboard using the Edit in chart option

Including HTML

The Markdown editor interprets Markdown first and foremost. While it is possible to incorporate HTML, it helps to think of these more as text documents than true HTML files. When formatting your code, keep the following in mind:
  • Indentation is interpreted as a code block. Keep your code flush to the left to prevent unintended code blocks.
  • Empty lines may cause odd behavior. In Markdown, these are paragraph indicators. This occurs because the div is included in a code block as plain text, which will strand its closing tag.
Omni sanitizes your HTML and CSS to prevent potential security vulnerabilities. This includes removing JavaScript and interactive elements such as <form>, <input>, and <script>.When an element is removed for security reasons, a message will appear in the Markdown: “This element is considered dangerous and will not be rendered.”

Best practices

While you can use HTML, try to use it sparingly to simplify things. If you do need to use HTML elements:
  • Use supported semantic HTML elements where possible, such as article or section. Large numbers of divs in a row can cause parsing issues.
  • Limit the depth of divnesting . Deeply nested elements increase the likelihood of conflicts between the Markdown and HTML parsing.
  • Use <style></style> and CSS classes over inline style tags for custom CSS.

Limitations

  • PDFs in deliveries and downloads may render differently than what’s visible in a browser,, including:
    • Directly referencing native HTML tags - for example, h3 { font-size: 18px; } may not always work
    • Some characters in CSS can’t be parsed causing those style declarations to be ignored, including:
      • The quotation marks needed for content: "<value>"; will not work
      • &. and &: notation in your CSS will be ignored. Do not use this syntax if you nest your CSS.
  • Invalid HTML or CSS syntax may not render correctly in PNGs or PDFs even if it correctly renders in a browser. For example, @media

Dark mode styling

When your Omni instance is in dark mode, the Markdown visualization automatically receives a prefers-dark class. You can use this class to apply different styles based on the theme. To target elements in dark mode, use the &.prefers-dark selector in your CSS:
<style>
  h1 {
    color: red;
  }

  .custom-element {
    background: green;
  }

  &.prefers-dark h1 {
    color: blue;
  }

  &.prefers-dark .custom-element {
    background: yellow;
  }
</style>
In this example, h1 elements will be red in light mode and blue in dark mode. The custom-element class will have a green background in light mode and yellow in dark mode.

Referencing query elements

Data and other elements from the query can be exposed using Mustache syntax. For example, {{query_element}}. The full list of query elements can be seen using {{ inspect }}. To reference query elements, you can do any of the following:
1
Use the Query details dropdown menu inside the Markdown editor.
2
Click any cell in the results table to copy the Markdown syntax:Right-clicking a cell in the results table to copy the Markdown syntax
3
Write the syntax directly, for example:
# Example field reference
{{fields.blob_sales_view.total_sales_field.label}}

# Example filter reference
{{filters.blob_sales_view.total_sales_field.value}}
Refer to the Markdown Mustache syntax reference for more information and examples.

Looping through the results set

To iteratively generate Markdown tiles based on the results set, use {{#result}} and {{/result}} to create a loop. For example:
{{#result}} // start a loop
{{<view_name>.<field_name>.value}} // access contents of that loop  [...]
{{<view_name_n>.<field_name_n>.value}} // reference more fields  
(<br>) // // maybe add a newline to create sections
{{/result}} // end loop
Check out these examples to see this pattern in action:

Adding visual components

Along with adding images and code to help highlight your data, you can also use the built-in components to create inline visualizations:
  • Change arrow - Adds an arrow icon indicating the type of change between two data points
  • Sparkline - Adds a sparkline. Useful for seeing the shape in variation in a condensed way.
More complex visualizations are possible - check out the Markdown examples gallery for inspiration.

Change arrow

Adds an arrow icon indicating the type of change between two data points. If the change is a positive number, the arrow will be green. If negative, it will be red. To use this component, your results must include two data points that can be used to calculate a change. A ChangeArrow component displaying a green upward arrow between two data points
<ChangeArrow current="{{result.0.users.count.value_static}}" comparison="{{result.1.users.count.value_static}}"></ChangeArrow>

Properties

NameValueNotes
currentresult.0.view_name.field_name.value_staticUse value_static instead of value, since the value and not the drillable element is needed
comparisonresult.1.view_name.field_name.value_static

Sparkline

Adds a sparkline. Useful for seeing the shape in variation in a condensed way. To use this component, your results must have more than one row of data and a field name. A Sparkline component displaying a small line chart inline with text
<Sparkline field="users.count" color="cornflowerblue"></Sparkline>

Properties

NameValueNotes
colorCSS color, ex: cornflowerblue
fieldview_name.field_name
heightInteger, ex: 4
widthInteger, ex: 4
reversetrueRemove property for false
typeline (default) or bar

Adding iframes

Using iframes in a Markdown visualization is also supported. iframes can be parameterized with query elements. By default, Omni applies restrictions (sandboxing) when rendering iframes. This means that some website features, such as popups, may be unavailable or incompatible. Use the dropdowns to check out some examples.
Before embedding in Omni, publish the doc and retrieve its embed link.
Code:
<iframe width="650" height="450" src="https://docs.google.com/document/d/id"></iframe>
Result:A Google Doc embedded in a Markdown visualization using an iframe
Code:
<iframe width="200" src="https://google.com/search?igu=1&q={{result._first.customers.name.value_static}}+company&tbm=nws&source=lnms&sa=X&ved=2ahUKEwjv1rPg7LmAAxXsFFkFHWTbCYcQ0pQJegQIPxAB&biw=1420&bih=840&dpr=2"></iframe>
Result:Google News search results embedded in a Markdown visualization using an iframe
Code:
<iframe src="https://www.google.com/maps/embed/v1/search?q={{result.0.products.brand.value_static}}+in+{{result._first.users.city.value_static}},{{result._first.users.state.value_static}}&key=AIzaSyCXfF4zpXaYkgVaBzj3oZUtmcDAxpdoOGk&" width="100%" height="100%"></iframe>
Result:A Google Maps embed in a Markdown visualization using an iframe
Code:
<iframe height=250 width=550 src="https://twitframe.com/show?url=https%3A%2F%2Ftwitter.com%2Fjack%2Fstatus%2F20"></iframe>
Result:A tweet embedded in a Markdown visualization using an iframe
Code:
<iframe width="650" height="450" src="https://embed.windy.com/embed2.html?lat=39.018&lon=-77.539&detailLat=39.018&detailLon=-77.539&width=650&height=450&zoom=5&level=surface&overlay=wind&product=ecmwf&menu=&message=&marker=&calendar=now&pressure=&type=map&location=coordinates&detail=&metricWind=default&metricTemp=default&radarRange=-1"></iframe>
Result:A Windy weather map embedded in a Markdown visualization using an iframe
Code:
<iframe width="560" height="315" src="https://www.youtube.com/embed/lNAzOJrV-Zk" title="YouTube video player"></iframe>
Result:A YouTube video embedded in a Markdown visualization using an iframe
Check out the Markdown examples gallery to get inspired!