Getting Started
RowShare Tables
What can I find on the RowShare homepage?
What are the basics of RowShare?
How to create a RowShare table?
How to transfer rows between your RowShare tables?
How does the RowShare form view work?
How do RowShare notifications work?
How do RowShare custom views work?
How to add, modify and delete rows?
Table Columns
How to create, modify and hide your RowShare columns?
What are the different types of RowShare columns?
How to use Formulas in your RowShare tables?
How to configure your RowShare columns?
Creating a link between the rows of two tables
Visualize your data
How can you visualize your data in RowShare?
How do RowShare charts work?
How to analyze your RowShare data?
How do I connect RowShare to Microsoft Power BI?
Display a RowShare table as a Calendar
Sharing and Confidentiality
How to share your RowShare tables?
How to assign your RowShare rows?
Control who can access specific columns
What are the permissions of a RowShare table admin?
How to create anonymous forms with RowShare?
How to send a reminder to row owners of your RowShare tables?
How to share your RowShare tables in Microsoft Teams?
How to identify the permissions of each user with Permission Audit?
Folders and permissions
Subscription and Account Settings
How do I edit my RowShare subscription options?
How to invite and manage your RowShare users?
How to manage your subscription?
What system notifications can RowShare send me?
What communications can I receive from RowShare?
What happens to my RowShare account if I am inactive?
How do I delete my RowShare account?
How do I view and change the time zone associated with my account?
What are my options for logging into my RowShare account?
RowMerge Document Generation
What is RowMerge? How does it work?
How to generate documents with RowMerge?
How to create, add or modify a RowMerge template?
How to manage variables and conditions with RowMerge?
How to use JavaScript in your RowMerge templates?
RowShare and Excel
How to create a RowShare table from an Excel file?
How to edit a RowShare table in Excel?
How do I export a RowShare table to Excel?
How do advanced Excel imports work?
RowShare Advanced Features
How to integrate RowShare into your applications with Zapier?
How does the RowShare API work?
How to Archive Rows in RowShare tables?
How do I view the modification history of my RowShare tables?
untitled article
FAQ
How do I receive a deadline reminder before the real deadline?
My RowShare subscription was deactivated, what happened?
What information is collected when using a social login?
How can I be notified when someone modifies a RowShare table?
How do I recover deleted RowShare rows?
How can I recover a deleted RowShare table?
Is there a maximum number of rows per RowShare table?
Where do I find my last RowShare invoice?
Can I hide RowShare columns?
Can anyone without a RowShare account edit a table?
How do I save a RowShare table?
Can RowShare subscriptions have more than one administrator?
How do I delete a RowShare table?
How is RowShare different from Google Sheets or Excel Online?
How do I register or log in?
What is my RowShare login?
How do I cancel my RowShare subscription?
How can I contact the RowShare support team?
Can I get notifications about specific rows?
Where does RowShare store my data?
Excel Sync doesn't work
Can I import a CSV file?
Is it possible to change the email address associated with my RowShare account?
What browsers and Excel versions are supported by RowShare?
How can I change my RowShare password?
Legal and Policies
- All Categories
- Visualize your data
- How to analyze your RowShare data?
How to analyze your RowShare data?
Updated by Antoine Driard
Once you have gathered data from all your remote users, you're not always done. You now need to understand it to make informed decisions. You might also want to track progress while your data is being entered.
RowShare analyzes your data the way you want without requiring any technical expertise. You want to analyze your by team? by geography? by status? by owner? Head to the appropriate column, click on the column menu, then "Analyze by xxx", and voilà! It couldn't be easier.
For each group of rows, you can see the numerical values aggregated. You can get a sum, average, max, min, first, last... of each group.
In the following example, we have a Sales forecast that we'd like to have analyzed by Sales Team. Head to the Team column menu, click on "Analyze by Team", and that's it:
That way, all metrics are calculated by group of rows (here target, forecast, attainment...). It's also very easy to only show the groups you want to focus on.
To undo the Analysis and restore the initial table, you can either click on the same column menu, then "Stop analysis", or click on the cross next to the group information, just above the table, on your right:
If you want more control, more options, open the Columns Panel at the right of the table to:
- Hide and show columns
- Analyze by columns
- Select the aggregate for each numerical value: sum, average, max, min, count, first, last