SDL Community
SDL Community
  • Site

SDL Trados Studio

SDL Trados GroupShare

SDL Trados Business Manager

SDL Trados Live

SDL MultiTerm

SDL Passolo

SDL Speech to Text

SDL Managed Translation - Enterprise

SDL MultiTrans

SDL TMS

SDL WorldServer

Translation Management Connectors

SDL LiveContent S1000D

SDL Contenta S1000D

SDL XPP

SDL Tridion Docs

SDL Tridion Sites

SDL Content Assistant

SDL Machine Translation Cloud

SDL Machine Translation Connectors

SDL Machine Translation Edge

Language Developers

Tridion Developers

Tridion Docs Developers

Xopus Developers

Community Help

SDL User Experience

Language Products - GCS Internal Community

SDL Community Internal Group

SDL Access Customer Portal

SDL Professional Services

SDL Training & Certification

Style Guides

Language Technology Partner Group

SDL Academic Partners

SDL Enterprise Technology Partners

XyUser Group

ETUG (European Trados User Group) Public Information

Machine Translation User Group

Nordic SDL Tridion Docs User Group

SDL Tridion UK Meetup

SDL Tridion User Group New England

SDL Tridion West Coast User Group

SDL WorldServer User Group

Tridion Docs Europe & APAC User Group

Tridion User Group Benelux

Tridion User Group Ohio Valley

SDL MultiTerm Ideas

SDL Passolo Ideas

SDL Trados GroupShare Ideas

SDL Trados Studio Ideas

SDL Machine Translation Cloud Ideas

SDL Machine Translation Edge Ideas

SDL Language Cloud TMS Ideas

SDL Language Cloud Terminology Ideas

SDL Language Cloud Online Editor Ideas

SDL Managed Translation - Enterprise Ideas

SDL TMS Ideas

SDL WorldServer Ideas

SDL Tridion Docs Ideas

SDL Tridion Sites Ideas

SDL LiveContent S1000D Ideas

SDL Contenta S1000D

SDL XPP Ideas

Events & Webinars

SDL Training & Certification

To SDL Documentation

To SDL Support

What's New in SDL

  • User
  • Translate

    Detecting language please wait for.......


    Powered by
  • Search
  • Site
  • Search
  • User
Translation Productivity
  • Product Groups
  • More
Translation Productivity
Customer Experience Excel Tips for Reporting
  • Blogs & Product Updates
  • Leaderboard
  • Forums
  • Resources
  • Events
  • Wiki
  • Training
  • More
  • Cancel
  • New
Show Translation Options

Detecting language please wait for.......


Powered by
Translation Productivity requires membership for participation - click to join
  • +Customer Experience
  • -SDL AppStore
    • +AdaptiveMT Trainer
    • +Amazon Translate MT provider
    • +Antidote Verifier
    • +Apply Studio Project Template
    • +ApplyTM template
    • +AutoHotKey Manager (AHK)
    • ChangeLog SDL InSource
    • +CleanUp Tasks
    • +Community Advanced Display Filter
    • +DeepL MT Provider
    • +DSI Viewer
    • +Excel Terminology Provider / TermExcelerator
    • -Excel4GroupShare
      • ChangeLog: Excel4GroupShare
      • Excel Tips for Reporting
    • +Export Analysis Reports
    • +Export To Excel
    • +Fail Safe Task
    • +Google API Validator
    • GroupShare Kit
    • GroupShare Version Fetch - Authentication options
    • +Hunspell Dictionary Manager
    • +IATE Real-Time Terminology
    • +IRIS PDF OCR Support for Studio
    • +Lingotek TMS plugin for SDL Trados Studio
    • +MEMSOURCE CloudTM Provider
    • Microsoft Translator Credentials for MT Enhanced App
    • +MT Comparison
    • +MT Enhanced Plugin for Trados Studio
    • MXLIFF File Type Support
    • +PA Admin
    • Post-Edit Compare
    • +projectTermExtract
    • Qualitivity
    • +Rapid Add Term
    • +RecordSource TU
    • +Reports Viewer Plus
    • +SDL Analyse
    • +SDL Batch Anonymizer
    • SDL Copy Tags
    • +SDL Data Protection Suite
    • +SDL Freshstart
    • +SDL InSource
    • +SDL LegIt
    • +SDL Machine Translation Cloud (former BeGlobal)
    • +SDL Machine Translation Edge Provider (former SDL ETS)
    • +SDL MultiTrans Plug-in for SDL Trados Studio
    • +SDL Number Verifier
    • +SDL Studio InQuote
    • +SDL T-Window for Clipboard
    • SDL TMBackup
    • +SDL Trados Studio Word Cloud
    • SDL TTS
    • +SDLTM Import Plus
    • +SDLXLIFF Convertor for MS Office
    • +SDLXLIFF Split / Merge
    • +SDLXLIFF to Legacy Converter
    • SDLXLIFF Toolkit
    • Signoff Verify Settings
    • +Star Transit (TransitPackage Handler)
    • +Studio Migration Utility
    • +Studio Subtitling
    • +Stylesheet Preview
    • +Target Word Count
    • +TM Lifting (ReIndex Translation Memories)
    • +TM Optimizer
    • Trados 2007 Translation Memory
    • +Wordlight
    • +WorldServer Compatibility Pack for SDL Trados Studio
    • +XLIFF Manager for SDL Trados Studio
    • +XML Reader
  • +SDL Support Team wiki
  • +Support & Maintenance

Excel Tips for Reporting

The raw data pulled from GroupShare has been designed to make it possible to create complex reports in as many ways as possible.  This means there is a trade-off between how much granularity we wanted and how much skill you need in using Excel to get what you need.  It also means a huge trade-off in terms of the time it takes to download data since the application is doing some very complex lookups between tables to pull the data in a way that makes it accessible for reporting.

Simple Reporting

For very simple reports you can of course use the filtering capabilities in Excel under the Home ribbon:

You can also add columns for your own calculations, and these can often be helpful to improve the more complex reporting by manipulating the data tables in Excel before creating your reports.  It can take some thought to report accurately on what you need and to ensure you are not duplicating or omitting details.  A good check is always to look in GroupShare and make sure you have the simple stuff right, such as number of organisations, or projects, as a cross check.

Detail Reporting

For detailed reporting your best bet is to use a Pivot Table.  If you have not used these before here's a couple of useful tips.

Add to your Quick Access bar in Excel

This make it far easier and faster to access the menu item needed.  First of all access the More Commands menu...:

Select All Commands from the drop down and then Add>> using the add button the PivotChart & PivotTable to your list of commands that will be displayed in the Quick Access Toolbar:

Now you can select all the data from your downloaded worksheet and start the Pivot creation process in one-click:

It's also worth noting that you probably need to check this option which is not selected by detail:

This is because it adds an additional value called Distinct Count to your choice when setting the Values field in your pivot.  Without this you don't have this option and the results of yor reports may contain duplicate counts depending on how you compiled your report:

Pivot tables work by allowing you to drag and drop the fields you want from the field list at the top (essentially the column headings from your download) into the four different areas at the bottom:

You can manipulate this as much as you like and you'll soon get the idea of how useful this can be as you see the tables and charts being drawn automagically in front of you.  Some good resources would be:

https://www.excel-easy.com/data-analysis/pivot-tables.html

https://support.office.com/en-us/article/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576

  • Share
  • History
  • More
  • Cancel
Related
Recommended
  • Our Terms of Use
  • Copyright
  • Privacy
  • Security
  • Anti-slavery Statement
  • Cookie Notice
  • YouTube