Converting to Date/Time

If you use a generic data importer such as 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. Keshif also lets you easily  extract and explore month, day-of-week, etc. of date fields.

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 from input, and then even allow you to edit on a calendar view. Once the data is correctly recognized, importing it to Keshif becomes easier.

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 show the full date-time information extracted from this field.

You can also create your date field easily after you start creating dashboards, so you don't need to worry about getting it right at the first page!

Importing Dates from CSV Files

The date information in a CSV file will be recognized as an integer (such as when you have a year attribute), or text (such as when you have a formatted time attribute like "10/1/2013").

Once you import a CSV file, you can parse the date field in the preview window, or directly within the dashboards.

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 you don't need to worry about getting it right at the first page!

Importing custom date formats

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.

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