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.

You can also create your date field easily after you create a dashboard, so you don't need to worry about getting it right at the import page!

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.

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, including 12/30/20015, 12/30/15, 2015-12-30, or other custom specifications.

Specifying a custom date format

If your date field format is not among listed options in Keshif, you can parse it by specifying your own format.  Internally, 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. 

Questions?

We recognize that this documentation is complex to follow, so do not hesitate to contact support@keshif.me to tell us about your data, and we'll be happy to return with more information specific to your case.

Still need help? Contact Us Contact Us