DataWorks:Analyze data using online spreadsheet

Version limits

• Visualization chart limits: The Basic Edition is limited to seven chart types. To access more chart types, you can upgrade to DataWorks Standard Edition or a higher edition.

• Spreadsheet sharing limits: The maximum number of editors and viewers that you can specify varies by edition.

  Feature/Edition	Basic Edition	Standard Edition	Professional Edition	Enterprise Edition
  Maximum number of editors	0	3	5	10
  Maximum number of viewers	0	10	20	30

Go to Spreadsheet

On the DataAnalysis page, click Go To DataAnalysis. In the menu bar on the left, click the or icon to open the Spreadsheet page.

Create a spreadsheet

Before you analyze data, you must create a spreadsheet to hold the target data.

Import data into a spreadsheet

Spreadsheet support direct data entry and importing data from local files for data analysis.

On the spreadsheet editing page, click the Import button in the upper-right corner. You can import Spreadsheet, Local CSV Files, or Local Excel Files.

Analyze data

Spreadsheet provide a rich set of data analysis operations similar to those in Microsoft Office Excel. On the spreadsheet editing page, you can set the font, alignment, number format, rows and columns, conditional formatting, and styles. You can also profile the data in the spreadsheet.

View and manage spreadsheet

1. On the spreadsheet editing page, click Spreadsheet in the upper-left corner or the icon in the left menu bar to navigate to the spreadsheet list page.

2. On the Spreadsheet page, in the All Spreadsheets area, you can view the spreadsheet in the I Created and Share it with me lists.

3. On the list page, you can manage spreadsheet as follows:

   • Rename: Click the icon next to the file. In the Rename dialog box, enter a new name in the File Name field and click OK.

   • Change Owner: Click the icon next to the file. In the Change Owner dialog box, enter and select the new owner, and then click OK.

   • Clone: Click the icon next to the file. A new file with the _copy suffix is created.

   • Delete: Click the icon next to a file. In the Delete dialog box, click OK.

4. Click a File Name to reopen the spreadsheet's editing page.

Export, share, and download spreadsheet

After you process and analyze data in an online spreadsheet, you can export, download, or share the data with specified users.

Appendix: Button details

On the spreadsheet editing page, you can configure the following items:

• Font

  Ordinal Number	Feature	Description
  ①	Font	Select the font type.
  ②	Font Size	Select the font size.
  ③	Bold	Make the text bold.
  ④	Italic	Italicize the text.
  ⑤	Underline	Add an underline to the text.
  ⑥	Strikethrough	Add a strikethrough to the text.
  ⑦	Border	Add a border to the text.
  ⑧	Background Fill	Fill the background color of the text.
  ⑨	Text Fill	Change the color of the text.

• Alignment

  Ordinal Number	Feature	Description
  ①	Top Align	Align text to the top.
  ②	Middle Align	Align text to be centered between the top and bottom of the cell.
  ③	Bottom Align	Align text to the bottom.
  ④	Auto Wrap	Display long text on multiple lines to make it all visible.
  ⑤	Align Left	Align text to the left.
  ⑥	Center	Center text horizontally.
  ⑦	Align Right	Align text to the right.
  ⑧	Merge and Center	Combine the selected cells into one larger cell and center the content in the new cell.

• Number

  Ordinal Number	Feature	Description
  ①	Data Type	Select the cell format, such as Number, Currency, Short Date, Long Date, Time, Percentage, Fraction, Scientific, and Text.
  ②	Percentage	Set the data type of the cell to percentage.
  ③	Two Decimal Places	Format the data in the cell to two decimal places.
  ④	1000 Separator	Separate thousands in the cell's data with a comma, for example, 1,005.
  ⑤	Currency	Set the data type of the cell to currency, such as CNY, USD, GBP, EUR, and CHF.

• Rows and Columns

  Ordinal Number	Feature	Description
  ①	Insert Row	Add a new row of cells to the spreadsheet.
  ②	Insert Column	Add a new column of cells to the spreadsheet.
  ③	Delete Row	Delete the selected row of cells from the spreadsheet.
  ④	Delete Column	Delete the selected column of cells from the spreadsheet.
  ⑤	Lock Row	Freeze all rows above the selected row in the spreadsheet.
  ⑥	Lock Column	Freeze all columns to the left of the selected column in the spreadsheet.
  ⑦	Hide Row	Hide the selected row in the spreadsheet.
  ⑧	Hide Column	Hide the selected column in the spreadsheet.

• Conditional Formatting

  Ordinal Number	Feature	Description
  ①	Filter-based Conditional Formatting	Includes rules in Highlight Cells Rules and Top/Bottom Rules.
  ②	Color Fill Conditional Formatting	Includes styles in Gradient Fill, Solid Fill, and Color Scales.
  ③	Icon Fill Conditional Formatting	Includes Directional, Shapes, Indicators, and Ratings icons.
  ④	Clear Conditional Formatting Effects	Includes Clear Rules From Selected Cells and Clear Rules From Entire Sheet.

• Style

  Ordinal Number	Feature	Description
  ①	Apply Table Style	Select and apply a table style.
  ②	Delete	Remove the applied table style.
  ③	Cell Style	Set the style of the cell.
  ④	Clear	Includes Clear All, Clear Contents, and Clear Formats.

• Edit

  Ordinal Number	Feature	Description
  ①	AutoSum	Supports five types: Sum, Average, Count Numbers, Max, and Min.
  ②	Search	Click Search directly, or use the keyboard shortcut Ctrl+F to open the input box.
  ③	Sort and Filter	Filter data and sort it in ascending or descending order.
  ④	Clear	Directly delete the selected content.

• Charts

  Ordinal Number	Feature	Description
  ①	Column Chart	For more information, see Column chart.
  ②	Line Chart	For more information, see Line chart.
  ③	Pie Chart	For more information, see Pie chart.
  ④	More	Click More to select charts such as: Area chart Bar chart Scatter chart Stock chart

• Plugins: This section provides the Type Conversion feature. Click the icon to apply Convert To Numeric or Convert To String to the selected data.

• Keyboard Shortcut List: Click the icon to view the shortcuts for each feature.