User Tools

Site Tools


transformations:makedatetimecolumns

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Last revisionBoth sides next revision
transformations:makedatetimecolumns [2021/04/23 18:17] craigttransformations:makedatetimecolumns [2021/07/15 12:28] craigt
Line 64: Line 64:
   * __The Column Profile/Filter window:__  In the //Values// tab, you will see date/time values leading with the date serial number (e.g., 32888  15-Jan-1990), while text-based values will only show the value (e.g., 15-Jan-1990).  In the //Metadata// tab, the number format for date/times will be "dd-MMM-yyyy" while text values will not have a number format.   * __The Column Profile/Filter window:__  In the //Values// tab, you will see date/time values leading with the date serial number (e.g., 32888  15-Jan-1990), while text-based values will only show the value (e.g., 15-Jan-1990).  In the //Metadata// tab, the number format for date/times will be "dd-MMM-yyyy" while text values will not have a number format.
   * __Analysis View, Table metadata:__ Date/time column values will show counts under "numbers" and "integers" while text-based values will show counts under "text" (These same results will appear using the //Table metadata// action.)   * __Analysis View, Table metadata:__ Date/time column values will show counts under "numbers" and "integers" while text-based values will show counts under "text" (These same results will appear using the //Table metadata// action.)
- 
- 
- 
  
 \\  \\ 
Line 87: Line 84:
 | 2020-Nov-29  | 2020-Q4  | Sun  |  48| | 2020-Nov-29  | 2020-Q4  | Sun  |  48|
 | 2020-Nov-30  | 2020-Q4  | Mon  |  49| | 2020-Nov-30  | 2020-Q4  | Mon  |  49|
 +
 +\\ 
 +====Community examples====
 +  * [[https://community.easymorph.com/t//1587/7|How to format the duration in more than 24h]] ([[https://community.easymorph.com/uploads/short-url/w6CnxwiidYjcJHNRrmUIXI74NC2.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 1//; Action position: //5//)
 +  * [[https://community.easymorph.com/t//2297/2|Excel: Import Date Headings as number]] ([[https://community.easymorph.com/uploads/short-url/ppgiXxeiQbK0O3owwca3pxAsOyH.morph|Project]]; Module: //Main//; Group: //Group 1//; Table: //New header//; Action position: //4//)
  
 \\  \\ 
transformations/makedatetimecolumns.txt · Last modified: 2021/07/19 02:24 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki