Use the Domo PowerPoint plugin to pull Domo cards into a PowerPoint presentation. This plugin provides much more power and flexibility than the other available methods for showing cards in PowerPoint.
- The Domo PowerPoint plugin can be used only in PowerPoint on Windows machines and is only supported by Office 2000 and later.
- This plugin can be used by Admin-, Privileged-, Editor-, and Participant-level users.
Video - PowerPoint Plugin
What you can do with the plugin
Using this plugin, you can do all of the following:
Connect to the server for the desired Domo instance.
Create a template for displaying cards in your presentation. You can include or exclude attributes such as card title, summary number, description, owner name, last modify date, and so on.
Specify the page in Domo that cards are being pulled from.
Refresh the cards in a presentation.
Specify the types of cards that are pulled into Domo (KPI cards, document cards, custom Apps, etc.).
Downloading the plugin
You can download the Domo PowerPoint plugin in the Admin Settings.
To download the Domo PowerPoint plugin,
In Domo, navigate to Admin Settings.
Select Tool Downloads.
Scroll down to the Domo PowerPoint plug-in section.
Click Try the PPT Plug-In.
After the plugin finishes downloading, follow the steps in the wizard to install it to your computer.
The plugin will now be available when you open PowerPoint.
Sequence of steps
The process for using the plugin to pull Domo cards into PowerPoint can be summarized as follows:
Connect to the server for the Domo instance you want to pull cards from.
Set up a template to control how cards will appear when pulled into PowerPoint.
Download the cards from the desired Domo page or subpage into PowerPoint.
After your presentation is saved, you can refresh the cards as necessary to keep the data up to date.
Parts of the Domo tab in PowerPoint
After you have installed the Domo PowerPoint plugin, a Domo tab appears near the end of the main tab row in PowerPoint. This tab appears as follows:
The following table describes the components of this tab:
|Connect to Domo||Lets you connect to a specified Domo instance.|
|"Templates" Options||Let you choose whether one, two, or four Domo cards appear in the currently selected slide.|
|"Custom Layout" Options||
Let you include various layout items in the currently selected slide. Visualization adds a single-card visualization layer to the slide. All of the other options add macros for swapping in text. For example, if you clicked Owner Name, a text macro reading "@DomoOwnerName-1" would appear under the visualization layer. This would then be replaced with the actual card owner's name when the card was pulled into Domo.
|Clear All||Deletes all layout attributes from the currently selected slide (including visualization layers).|
|Choose Page||Lets you specify a page in Domo from which to retrieve cards. The wizard populates with all pages you have access to.|
|Refresh Cards||Refreshes all of the cards in this PowerPoint presentation, updating the underlying data as necessary.|
|Settings||Lets you specify the types of cards that are pulled from Domo into PowerPoint. You can choose KPI cards (here called "Chart Cards"), document cards, table cards, or custom Domo Apps. Here you can also turn Domo watermarks (Domo's logo on rendered card images) on or off. Be aware that this option requires a contractual agreement with Domo that allows for white label usage of this tool.|
|Help||Provides basic instructions for using the Domo PowerPoint plugin.|
Connecting to a Domo server
You can connect to the server for any Domo instance for which you have access.
To connect to a Domo server,
Click the Connect to Domo button on the left side of the Domo tab in PowerPoint.
A dialog appears requesting that you add a connection.
Enter the URL for your Domo server in the field, then click Next.
Enter your Domo credentials in the fields, then click Next.
If you have entered your credentials correctly, a "Success" dialog appears. In addition, an access token is created within Domo. For more information about access tokens, see Managing Access Tokens.
Setting up a card template
Before pulling Domo cards into PowerPoint, you must set up a template for them. The plugin pulls all cards from a page and allocates them according to the template in the currently selected slide. For example, if you select a slide with a four-card template then choose a Domo page with 32 cards, those cards would populate the next eight slides in your presentation, with four cards appearing per slide as per your template.
You can also insert text macros for swapping in card text attributes such as title, description, owner name, and so on. When the cards are pulled in, the real text will replace the macros you have inserted. All macros are prefaced with a @ symbol and are thus easily identified.
You can edit Domo card layout items just as you can any other elements in PowerPoint. For example, you can add text, move elements around on a slide, and so on.
This section discusses the various options available for setting up card template layouts.
Specifying the number of cards in a slide
You can specify whether one, two, or four cards is added to a template. You do this by clicking Single Card, Dual Card, or Four Cards, respectively, in the Domo toolbar. If you click one of these options in a blank slide, a visualization layer is added to the slide, divided into the specified number of card templates. If you click one of these options in a slide that already contains a template, that option replaces the current template. For example, if the slide contains a two-card template and you click Four Cards, the four-card template replaces the two-card template.
The single-card and two-card templates come with preinserted text macros for swapping in text. You can move these, remove them entirely, or add different ones if desired.
The single-card template includes macros for the card title, summary number, description, owner name, and last update date, as follows:
The dual-card template includes macros for the titles, summary numbers, owner names, and last update dates for both cards, as follows (note that description text macro does not appear by default):
The four-card template does not include preinserted text macros; however, you can insert these manually using the Custom Layout options. These are described in the next section.
Inserting text using Custom Layout macros
For any card template, you can insert macros for card attributes such as title, description, owner, etc. As described above, when you pull cards into Domo, the real attribute text replaces the macros.
The following macros are available:
|Card Title||The title of this card as it appears in Domo. For more information about setting card titles, see Editing the Name or Description of a KPI Card.|
|Summary Number||This card's summary number as it appears in Domo. For more information about configuring summary numbers, see Configuring Your Chart Summary Number.|
|Description||The description of this card as it appears in Domo. For more information about adding or editing a card's description, see Editing the Name or Description of a KPI Card.|
|Owner Name||The name of the Domo user who owns this card. For more information about card ownership, see Changing a Card Owner.|
|Data Last Updated||The date when the data in this card was last refreshed. For more information, see Updating or Refreshing the DataSet for a KPI Card.|
|Card Last Modified||The date when this card was last edited. For more information, see Understanding Cards.|
The other option in this list, Visualization, is not a text macro. This is the macro that pulls in the actual content for a given card. These macros appear in the following format: @DomoVisualization-x, where x is the number corresponding to this visualization on the slide. This is important because all text macros also end with a number, which matches the number of the corresponding visualization. So, for example, if you had a four-card template, the visualizations would be numbered 1 through 4. If you then inserted an Owner Name macro, it would appear as follows: @DomoOwnerName-1. Then, if you were to pull in cards for this slide, this macro would be replaced by the name of the owner for @DomoVisualization-1. Make sure you match up your text macros with the correct visualizations, or you could end up with cards paired with the wrong attributes!
Removing everything from a slide
You can quickly remove all visualization layers and macros from a slide by clicking Clear All in the Domo tab.
Pulling cards into PowerPoint
After you have set up a card template as described in the previous sections, it is time to pull Domo cards into PowerPoint based on your template. You do this by clicking Choose Page then following the steps in the wizard.
Before doing this, you may want to specify the types of cards pulled into PowerPoint when you import. Currently the following types of cards can be pulled from Domo into PowerPoint:
KPI cards ("chart cards")
Custom Domo Apps
Sumo cards (only pulls Sumo table data, not card attributes such as colors, etc.)
Poll cards and notebook cards cannot be pulled into PowerPoint at this time.
You can select and deselect the types of cards pulled into PowerPoint from Domo in the DomoOfficeSettings dialog, which you can access by clicking Settings in the Domo tab. For each type of card, you can toggle it on ("Enabled") or off ("Disabled"). For example, in the following screenshot, all card types are enabled and will be pulled into PowerPoint upon import except for custom Domo Apps.
Once you have set up your templates and established the types of cards to be pulled, you can select the page with cards to retrieve. You do this in the Get Cards dialog, which you can access by clicking Choose Page in the Domo tab. This dialog lists all Domo pages and subpages you have access to.
To download Domo cards into PowerPoint,
Select the PowerPoint slide that contains the template you want to base your cards on.
Click Choose Page in the Domo tab.
Scroll down to navigate to the page or subpage you want, or filter the list using any of the filters at the top of the dialog.
The first filter lets you filter by entering the name of the desired page; the second filter lets you choose from parent pages; and the third filter lets you filter by page owner.
Once you find the page you want to import from, select it then click Next.
All of the cards of the type(s) you enabled in Settings are downloaded.
Click Create Slides.
The Domo cards you have downloaded are inserted into the slides in your presentation.
Using Page Filters
You can use the Page Filter feature in Domo to further filter your Domo content before exporting to PowerPoint. In order to use this feature,
- Navigate to the page containing the content you wish to filter
- Create and apply your Page Filter
- Click SAVE FILTERS to save your page filter to the page.
- Go to the PowerPoint Plugin and choose the page containing the content you wish to include
- When choosing the page, be sure that Apply Page Filters is On
- Select the cards you wish to include in your presentation
Refreshing Domo cards in a presentation
You can refresh a presentation with Domo cards. When you do this, all cards in the presentation are updated to show the most recent data.
To refresh a presentation with Domo cards,
- Click Refresh Cards in the Domo tab.
All of the cards should update to show their most recent data.
Several users have reported an issue in which Microsoft disables the plugin after a crash; hence the plugin is still installed but is in a disabled state, so the Domo tab doesn't appear. Reinstalling the plugin leaves it in the disabled state. Below are instructions to re-enable the plugin.
To re-enable the PowerPoint Plugin,
Select File > Options.
In the Manage dropdown, select COM Add-ins, then click Go.
Check the box next to Domo PowerPoint then click OK.
If the box is already checked and the Domo tab still doesn't appear, make sure you don't have multiple versions of the plugin installed. You can remove extra instances by doing the following:
In the Windows Control Panel, go to Add/Remove Programs.
Remove all instances of "Domo PowerPoint."
Reinstall the plugin.