Venus Control Suite Data Studio: How to use Data Transforms?

Topic

This article explains how to use Data Transforms in Data Studio to modify incoming data from a data source before it is used in a presentation. Data Transforms allow users to apply expressions to a Data Studio feed so incoming data can be adjusted to better meet presentation requirements, such as shortening text, removing extra decimal places, abbreviating values, or changing how data is formatted.

The Transform Preview allows users to compare the original feed data with the transformed output before saving changes.

 

      Environment

      • Product Family: Venus Professional, Venus Enterprise, Venus Live
      • Product: Data Studio
      • Component: Data Transforms
      • Control System: Venus Control Suite

      Steps

      ▶️Use the arrows to expand and collapse each section. 

       

      Access Data Studio and Select a Data Source

      Before using Data Transforms, ensure a data source is available.

      1. Log in to Venus Control Suite
      2. Navigate to the Data Studio app

      1. Select an existing data source or configure a new data source
      Use Data Transforms

      Use Data Transforms to modify and preview data before it is used in a presentation.

      1. Open the selected data source.
      2. Select the Transforms tab.
      3. Enable Data Transformation.
      4. Select a Data Feed.
      5. Enter a transformation in the JSONata Expression field.
      6. Review the results:
        • Original Feed JSON displays the source data
        • Transform Preview displays the transformed output
      7. Update the expression as needed to refine the output.
      8. Select Save to apply changes.

      The transform is saved to the selected feed and is applied to incoming data for that feed.

      Review the Transform Preview

      Use the Transform Preview to validate the transformed output before saving.

      1. Review the Original Feed JSON to confirm the incoming source data.
      2. Review the Transform Preview to confirm the transformed output.
      3. If the transformed output does not display as expected, update the JSONata Expression.
      4. Continue reviewing and updating the expression as needed.
      5. Select Save when the transformed output is correct.
      Uses Cases & Notes
      1. Data Transforms can be used to adjust incoming data for presentation needs. Common examples include:
        •  Removing extra decimal places from numeric values.
        • Abbreviating long school, team, or location names.
        • Shortening text so it fits better on a display.
        • Reformatting incoming data.
        • Creating a new field from existing data.
      2. Data Transforms apply to the selected Data Feed. A transform cannot pull data from a different feed and combine it with the selected feed.
      3. Transforms may be used with supported sources such as app sources, URL sources, file watcher sources, online spreadsheets, and calendars. Split feeds are not supported for Data Transforms.

       

      Related Resources
      Data Studio: How do I configure web data sources?
      Venus Control Suite Web Editor: How do I use filtering, sorting and effects?
      Venus Control Suite Data Studio Quick Guide

      KB ID: 000031932

      DISCLAIMER: Use of this content may void the equipment warranty, please read the disclaimer prior to performing any service of the equipment.

      DAKTRONICS DOES NOT PROMISE THAT THE CONTENT PROVIDED HEREIN IS ERROR-FREE OR THAT ANY DEFECTS WILL BE CORRECTED, OR THAT YOUR USE OF THE CONTENT WILL PROVIDE SPECIFIC RESULTS. THE CONTENT IS DELIVERED ON AN "AS-IS" AND "AS-AVAILABLE" BASIS. ALL INFORMATION PROVIDED IN THIS ARTICLE IS SUBJECT TO CHANGE WITHOUT NOTICE. DAKTRONICS DISCLAIMS ALL WARRANTIES, EXPRESS OR IMPLIED, INCLUDING ANY WARRANTIES OF ACCURACY, NON-INFRINGEMENT, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. DAKTRONICS DISCLAIMS ANY AND ALL LIABILITY FOR THE ACTS, OMISSIONS AND CONDUCT OF YOU OR ANY THIRD PARTIES IN CONNECTION WITH OR RELATED TO YOUR USE OF THE CONTENT. ADJUSTMENT, REPAIR, OR SERVICE OF THE EQUIPMENT BY ANYONE OTHER THAN DAKTRONICS OR ITS AUTHORIZED REPAIR AGENTS MAY VOID THE EQUIPMENT WARRANTY. YOU ASSUME TOTAL RESPONSIBILITY FOR YOUR USE OF THE CONTENT AND ANY LINKED CONTENT. YOUR SOLE REMEDY AGAINST DAKTRONICS FOR DISSATISFACTION WITH THE CONTENT IS TO STOP USING THE CONTENT. THIS LIMITATION OF RELIEF IS A PART OF THE BARGAIN BETWEEN THE PARTIES.

      The above disclaimer applies to any property damage, equipment failure, liability, infringement, or personal injury claim arising out of or in any way related to your use or application of the content, whether such claim is for breach of contract, tort, negligence or any other cause of action.