They have a base_type of numeric but a special type of DateTime. This
adds the check for special type when associating dimension options to
a field.

Fixes #5876

This commit wraps the timezone detections stuff in some try/catches so
that if there's an issue parsing one of the timestamps from the
database, it doesn't cause the whole sync process to fail.

If a failure happens, it's logged as a warning, the timezone field in
the database is not updated and the sync process proceeds.

Fixes #5869

* fix time granularity order

* add comment

Previously pulses were always rendered with UTC time, this commit
changes that to use the report timezone (if available and applicable)
otherwise the JVM timezone (similar to how query results are
returned).

Fixes #3109

* Add :largest-contributors to comparison, bug fixes, refactoring

* Add valid-pairs and field endpoints to comparisons

* Dampen field difference weight in contribution assesment

* fix nice-bins for empty histogram

* fix for nice-bins for histogram with only 1 value

* Change comparison field zoom in. Rename largest-contributor to top-contributor

* fix halfassed rename

* refactor + new components

* use true multiseries

* cleanup

* include constituents in card

* add dataset to card return

* card wip

* growth rate

* check for values

* lint

* cardify all series features. Unpack linear regression

* add linear regression

* use percentages

* flip order

* add growth series description

* add additional info

* fix layout

* layout tweaks

* add action in qb

* show growth series as a %

* xray segment action

* flow

* Support all time breakdowns, fix filtering bug

* make linter happy

* more robust test

* Add conditional descriptions for growth-series. Update tests.

* add periodicity to cards

* Update for updated distance measure

* Removed updates to comparison as they should not be part of PR

* Correct chi^2 distance

* fix headings

* fix flow

* disable flow for action

* use beaker for xray actions

* move specs to proper test directory

* Fix round-to-month when crossing year

* add key

* Add smoke tests for table xray and segment xray pages

* Correctly handle unixtimestamps encoded as bigints

* Add test cases for question xray page and segment xray query builder action

* Test also timeseries question action widget action

* Fix lint errors for xray tests

* Fix Histogram element passing data in invalid format to Visualization

* Fix integration tests for xrays

* Make xrays urls in services.js consistent with other urls

* fix periodicty reweighing

* add sample? predicate

* cleanup

* spacing

* cleanup

* fix failing tests

* fix failing tests

* Update tests

* Refactored periodicity reweighing, more tests

* Support :as in date-time fields, more tests, fix another periodicity bug

* add error handling

* add missing label

* tweak fidelity icon size

* fix histograms

* more specific legend hiding

* hide link for now

* card xray title

* fix field header

* fix stat group padding

* card error handling

* remove duplicated code

Expressions aren't columns, but they have an entry in the cols
property which currently doesn't have type info. This adds that which
allows it to be used as the Y-axis in graphs.

Fixes #3952

Field values and human readable values are zipped together to support
remapping. If the field values change (i.e. new values, removing
values etc) then the pairings of those field values and their remapped
values can be wrong. This commit adds some code to reconcile that. If
a new field value is found, a stringified version of that field value
is used as the human readable version (the user can update/change this
later).

Fixes #5782

* Add :largest-contributors to comparison, bug fixes, refactoring

* Add valid-pairs and field endpoints to comparisons

* Dampen field difference weight in contribution assesment

* fix nice-bins for empty histogram

* fix for nice-bins for histogram with only 1 value

* Change comparison field zoom in. Rename largest-contributor to top-contributor

* fix halfassed rename

* refactor + new components

* use true multiseries

* cleanup

* include constituents in card

* add dataset to card return

* card wip

* growth rate

* check for values

* lint

* cardify all series features. Unpack linear regression

* add linear regression

* use percentages

* flip order

* add growth series description

* add additional info

* fix layout

* layout tweaks

* add action in qb

* show growth series as a %

* xray segment action

* flow

* Support all time breakdowns, fix filtering bug

* make linter happy

* more robust test

* Add conditional descriptions for growth-series. Update tests.

* add periodicity to cards

* Update for updated distance measure

* Removed updates to comparison as they should not be part of PR

* Correct chi^2 distance

* fix headings

* fix flow

* disable flow for action

* use beaker for xray actions

* move specs to proper test directory

* Fix round-to-month when crossing year

* add key

* Add smoke tests for table xray and segment xray pages

* Correctly handle unixtimestamps encoded as bigints

* Add test cases for question xray page and segment xray query builder action

* Test also timeseries question action widget action

* Fix lint errors for xray tests

* Fix Histogram element passing data in invalid format to Visualization

* Fix integration tests for xrays

* Make xrays urls in services.js consistent with other urls

* fix periodicty reweighing

* cleanup

* spacing

* cleanup

* fix failing tests

This commit makes several changes intended to fix timezone related
issues and expose more information when there are problems. For
databases that support report timezones, this commit fixes an issue
where the JVM's timezone was used to interpret datetimes that didn't
include a timezone. The report timezone should be used instead. This
commit also adds a step to the sync process to detect and store the
databases timezone, which will be helpful in troubleshooting timezone
issues with a new timezone debugging page (to be added later).