Supported Data Types & Column Header Functions
Supported Data Types
Phiona automatically detects the following datatypes. While a majority of datatypes are treated as text values, certain values are treated as numbers or dates (noted below).
Text
Numbers
Boolean Values (Yes/No, etc)
Dates and Date/Time (treated as dates)
Currencies (support $, €, £, and ¥, treated as numbers)
Email Addresses
URLs
US State Abbreviations
US Zip Codes
International Phone Numbers
US Social Security Numbers
Credit Card Numbers
Column Header Functions
When clicking on a column header in a data, a dropdown menu will appear allowing you to select certain smaller datagrid view, transformation and filtering functions.
Number Columns
Dragging or Resizing the Column
Resize the column to a different size by hovering on the right of the header (a blue line will appear) and dragging left or right, or move the column to another part of the spreadsheet by selecting the column header and dragging it to the desired position.
Rename Column
Renames column to another header name.
Filter Column
Filter numbers to only the ones that are required in the dataset. For example: if you are looking to filter for the value "8", selecting Equals Value will show only numbers that are EXACTLY 8, whereas selecting Contains Value will show any number that includes an 8 in it, like "18" or "82".
Supported Operations: Contains Value, Does Not Contain Value, Equals Value, Greater Than Value, Less Than Value, Not Equal To Value
Transform Options
Performs mathematical transformations on each cell.
Supported Operations: Add Commas, Convert to Percentage, Remove Commas, Remove Decimal Points, Set to 2 Decimal Places, Set to 3 Decimal Places, Set to 4 Decimal Places
Sort Column
Sorts the numbers from the lowest value to the highest value or vice versa.
Display Options
Allows you to size the column automatically depending on the length of the data in the cells, or freeze the column in place so that you can scroll to the right while always seeing the data in this column.
Supported Operations: Autosize Column, Pin Column
Column Options
Perform actions on the column itself, like duplicating it, or adding a blank column to the left or right of the selected column.
Please note: deleting a column does not delete the raw data from the data source that was connected to Phiona!
Supported Operations: Add Column Left, Add Column Right, Delete Column, Duplicate Column
Text Columns
Dragging or Resizing the Column
Resize the column to a different size by hovering on the right of the header (a blue line will appear) and dragging left or right, or move the column to another part of the spreadsheet by selecting the column header and dragging it to the desired position.
Rename Column
Renames column to another header name.
Filter Column
Filter text to an exact match or containing match. For example, if you're filtering for the value "male", an exact match would bring up all of the exact "male" results while containing would also include "female" results as well.
Supported Operations: Contains Value, Does Not Contain Value, Equals Value, Not Equal To Value
Transform Options
Performs text transformation on the values.
Supported Operations: Capitalize, Lowercase, Trim Surrounding White Spaces, Trim White Spaces, Uppercase
Sort Column
Sorts the numbers from the lowest value to the highest value or vice versa.
Display Options
Allows you to size the column automatically depending on the length of the data in the cells, or freeze the column in place so that you can scroll to the right while always seeing the data in this column.
Supported Operations: Autosize Column, Pin Column
Column Options
Perform actions on the column itself, like duplicating it, or adding a blank column to the left or right of the selected column.
Please note: deleting a column does not delete the raw data from the data source that was connected to Phiona!
Supported Operations: Add Column Left, Add Column Right, Delete Column, Duplicate Column
Date Columns
Dragging or Resizing the Column
Resize the column to a different size by hovering on the right of the header (a blue line will appear) and dragging left or right, or move the column to another part of the spreadsheet by selecting the column header and dragging it to the desired position.
Rename Column
Renames column to another header name.
Filter Column
Filter text to an exact match or containing match. For example, if you're filtering for the value "2019", an exact match would bring up all of the exact "2019" results while containing would also include "01012019" results as well.
Phiona also supports exact date filtering, as well as relative data filtering compared to the current date.
Supported Operations: Contains Value, Does Not Contain Value, Equals Value, Not Equal To Value, After, Before, Day, Equals, Month, Range, Specific, Today, Week, Year, Yesterday
Sort Column
Sorts the numbers from the lowest value to the highest value or vice versa.
Display Options
Allows you to size the column automatically depending on the length of the data in the cells, or freeze the column in place so that you can scroll to the right while always seeing the data in this column.
Supported Operations: Autosize Column, Pin Column
Column Options
Perform actions on the column itself, like duplicating it, or adding a blank column to the left or right of the selected column.
Please note: deleting a column does not delete the raw data from the data source that was connected to Phiona!
Supported Operations: Add Column Left, Add Column Right, Delete Column, Duplicate Column
Last updated
