VALUE: Profiling and filtering dates in Paxata can provide a simple and fast method to understand the date/time characteristics of your data (such as trends, outliers, and unexpected values) which may need resolving prior to pushing the data into production. It’s a great way to validate you have been provided an accurate & complete set of data from upstream or third-party sources.
|Clicking on the clock icon of any Paxata date column will open a Filtergram at the “TIMELINE” level.
|You can access four additional charts (Hour of Day, Day of Week, Day of Month, and Month of Year) by clicking on the “5 available charts” button at the bottom-left of the Filtergram window.
You can view all 5 views at once if you like!:
Notice in the image at left, the datatype icon is “A-Z” which means the column datatype is text.
Also notice the date values in the cells are black color font. Date values in a Date-type column will appear as blue-green font.
You can convert text columns which contain dates into date datatype columns. Once this is done, the Date Filtergram functionality mentioned above will be available.
|The syntax to convert the @DATE_AS_STRING@ column from text to datetime type is:
DATEVALUE(@DATE_AS_STRING@ , “yyyy-MM-dd”)
|The resulting column will appear with a clock icon next to the column header name and the values will appear in blue-green font:
|For more information and guidance on using date/time filtergrams, refer to th Date/Time Filtergrams section of the Data Filters Knowledge Base article.|