Converting to Date/Time
When you import your data from Google Sheets or CSV files, date-time data may need to be converted before it can be explored effectively in Keshif. These conversations will make sure that you get the best automated interactive visualizations (a rich zoomable and date-filterable line chart), and will let you easily extract and explore month, day-of-week, etc .
Importing Dates from Google Sheets
To be able to successfully import date information, first ensure that the date values are correctly recognized by Google Sheets. Google Sheet will automatically try to detect date information in cells, and even allow you to edit dates a calendar view. Once the data is correctly recognized, importing it to Keshif is much easier and seamless.
Although it does not affect how data is imported to Keshif, you can format your date field using Sheet Menus : Format -> Number -> More Formats -> More Data and Time Formats. Learn more at Google Support.
Once you import a Google Sheet, you can parse the date attribute in the preview, or in the dashboards. To change the type in preview window, click the edit icon next to field name, select " Convert to DateTime", and choose "Serial/Sheet date". Your data preview will be updated to show the full date-time information extracted from this field.
Importing Dates from CSV Files
When you select a CSV file, the date information in a CSV file will first be recognized as an integer (such as when you have a year attribute), or text field (such as when you have a formatted time attribute like "10/1/2013"). Once the file is imported, you can parse the date field in the preview window, or directly within a dashboard.
To change the type in preview window, click the edit icon in field name, select "Convert to DateTime", and choose the format that matches your input. After this step, your data preview will show the full date-time information extracted from this field.
Specifying Date Attribute within Dashboard after Data Import
You can also create your date field easily after you start creating dashboards, so don't worry about getting it right at the import page!
Date formats for conversion
Keshif offers a range of date formats for each conversion, and you can also specify your own!
If you have a numeric date representation, Keshif can convert "years", "Serial/Sheet Dates" (such as returned by Google Sheet), and UNIX Timestamps.
If you have a textual date representation, Keshif can convert various date formats, such as 12/30/2015 (Month/Day/Year), 12/30/15 (Month/Day/Year), 2015-12-30 (Year-Month-Date). If your date field format is not among listed options in Keshif, you can parse it by specifying your own format.
Specifying a custom date format
You can specify a custom format by selection "Convert to DateTime" and then clicking "Custom".
Keshif uses d3's time formatting options, documented at https://github.com/d3/d3-time-format.
For example, to add a format that could parse 12/30/2015, you should enter %m/%d/%Y as the date format.
Please contact firstname.lastname@example.org for any questions or support, and we'll be happy to return with more information specific to your case.