You can create custom Insights using SQL queries and HTML for visualization. Here’s more on how to create an Insight.
If your Insight returns a single number (e.g., MRR, Number of Jira Epics…), Quantive can automatically create the user interface (UI) for your Insight – though, if you want, you can fall back on fully custom HTML.
To take advantage of automatic UI for your single value Insight,
Click on
Execute
after you write your SQL queryClick on
Automatic UI
To change formatting, click on Formatting options
.
You can adjust the following:
Decimal size - the number of decimal places you want the Insight value to display
Color - the color of your Insight value can be changed from black to green, red, etc.
Unit - a currency symbol or custom unit of measurement which can be placed before or after your Insight value
Once you’re satisfied with your formatting options, click Save
.