Create Visualizations with Blended Data
- Security: These domains in the System functional area:
- Discovery Boards: Create
- Drive
You can build Discovery Board visualizations that use your external tables and derived datasets.
- Create a Discovery Board.
- From the Workday header, select your profile picture and then selectDrive.
- Navigate to a folder.
- Select+ New > Discovery Board.
- Enter a name such as ZeroCopy_Analysis_.
- ClickCreate.
A new Discovery Board opens with a single blank visualization. - Add a visualization using only external data.
- In the Discovery Board, open theData Sourcespanel.
- In theSearch Data Sourcesprompt, search for the external data source associated with your external catalog.
- Select the external data source.
- Open theBuilder Panelto view available fields.
- To the right of theSearch Fieldsbox, click the down arrow next to the default visualization type and choose a chart that fits your data (Examples: Bar chart, column chart, donut chart).
- Drag one or more numeric measures from the external source into the appropriate blocks (Examples: Y-Axis, Angle).
- Drag a dimension field (Examples: A category, organization, or level) into the X-Axis, Color, or Filter blocks to segment the measure.
This creates a visualization that uses only the external data. - Add a visualization using the blended dataset.
- On the Discovery Board, selectAdd Vizto add another visualization.
- In theData Sourcespanel, select the Back arrow and search for the published dataset you created that blends Workday and external data.
- Select the dataset.
- Open theBuilder Panelto display the dataset fields.
- Choose a chart type that helps compare your key measures across categories or over time (Example: Column chart).
- Drag your primary measure (Example: Total or sum) into the Y-Axis block.
- Drag a relevant dimension (Example: Category, period, or organization field) into the X-Axis block.
- Optionally add more dimensions to Color or Filter to allow users to segment the results.
This creates a visualization that showcases the blended dataset. - Review and refine the board.Review the Discovery Board:
- Confirm that the first visualization is based only on external data.
- Confirm that the second visualization uses your published, blended dataset.
- Check that labels, titles, and legends make it clear what each visualization represents.
You can:
- Add filters (such as time period, organization, or population).
- Adjust formatting and layout so the board is easy to interpret.
- Share the board according to your needs.