User Types: Editor and Analyst Designations

Modified on Mon, 7 Oct at 5:21 PM

Under both the Gigasheet Business and Gigasheet Enterprise plans, users can be designated as either an Editor or an Analyst.

An Analyst has a subset of the capabilities available as an Editor. Analyst capabilities involve the presentation of data, including filtering, sorting, grouping, pivoting, and aggregating. Analysts have full access to all data within a sheet. Editors have all Analyst capabilities, plus the ability to add, edit, and delete Gigasheet data.

For a complete view of options, refer to the table below:

GETTING DATA IN
Capability	Editor	Analyst
Connect to a Cloud Data Warehouse	Yes	No
Upload Data	Yes	No
Create Blank Sheets	Yes	No
Save Results as a New Sheet	Yes	No
VIEWING DATA
Capability	Editor	Analyst
Access to all rows in Sheet	Yes	Yes
Paginate through sheets	Yes	Yes
Rename Sheet	Yes	No
Move Sheet to New Library Folder	Yes	No
DISTRIBUTING DATA
Capability	Editor	Analyst
Share Data	Yes	Admin Setting
Embed Data	Yes	No
Link Data to BI Tool	Yes	No
Download Data to Local Machine	Yes	Admin Setting
WORKING WITH DATA
Capability	Editor	Analyst
Filter Sheet Data	Yes	Yes
Group Sheet Data	Yes	Yes
Sort Sheet Data	Yes	Yes
Create Pivot Tables	Yes	Yes
Change Column Type	Yes	No
Mark Columns as Visible or Hidden	Yes	Yes
Split or Combine Columns	Yes	No
Rename Columns	Yes	No
Reorder Columns	Yes	Yes
Remove Duplicate Values from a Sheet	Yes	No
Chart Data	Yes	Yes
Flag Data	Yes	Yes
Calculate column aggregations	Yes	Yes
Calculate group aggregations	Yes	Yes
Comment on Sheets	Yes	Yes
Use Sheet Assistant	Yes	Yes, but with limitations on creating or deleting data
Save Views	Yes	Yes
Generate an API key	Yes	No
EDITING DATA
Capability	Editor	Analyst
Directly Edit Sheet Data	Yes	No
Join Data via Lookup	Yes	No
Copy Data Out	Yes	No
Paste in Data	Yes	No
Find and Replace Data	Yes	No
Delete Rows or Columns	Yes	No
Insert Rows or Columns	Yes	No
Run formulas	Yes	No
Label Columns with IF/THEN	Yes	No
Enrich Data	Yes	No
Explode Date Columns	Yes	No
Explode JSON Columns	Yes	No
Change Column Case	Yes	No
SUPPORT
Capability	Editor	Analyst
Live Chat with Support	Yes	Yes
Open Support Tickets	Yes	Yes