Profiling and Filtering dates

June 4, 2018

Profiling and Filtering dates

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.
Try Now
Show Buttons
Hide Buttons