How to use date time custom field as a dimension?

Hey folks how’re doing?

I’m trying to import 1 custom field as a dimension to use with a main filter in my dashboard, but the option is not avaiable!

Example:

image

I’d like to use the same way this filed Time (pages), but add my custom field (“Inicio Incidente”).

Did you check this?
Inside the Source Data for Customfields. Click on “Edit” link on the Advanced settings (right column) and then inside. You should have this (and select the checkbox of Dimension):

1 Like

Hey @Nacho tks for your help! But after change the configuration as you explain to me, I’m trying to import and I’m getting this error:

Cannot import changes for “Fim Incidente” (customfield_10479).
Only single value separate table dimensions are supported.

Hi,

There is just one “Time” dimension, and you can not create more dimensions in the “Issues” cube from date or datetime custom fields.

Instead you would need to search for measure “Issues with Inicio incidente” which can be used to get the count of issues by “Inicio incidente” date when using the default “Time” dimension.
Please watch this recording from presentation on Time dimension:
https://docs.eazybi.com/eazybi/learn-more/training-videos/videos-create-reports-and-charts#Videos:createreportsandcharts-It’sAboutTime

Also, this page should explain a bit more about measures with date picker field context.
https://docs.eazybi.com/eazybi/data-import/data-from-jira/jira-custom-fields#Jiracustomfields-Measureswithcustomdatefields

To summarize, you don’t have to change any options for the field. Make sure all 3 checkboxes remain imported and then use measure “Issues with Inicio Incidente” to filter report

Martins / eazyBI

1 Like

Tks @martins.vanags ! For a count of times that my custom field is used, your instructions worked well!

But I need to filter my dashboard using my datetime custom fileds as a main parameters because are different start and end dates if we compare with default created / end date from Jira!

For example:
image

At the image below, as I have different dates between “Created Date” default field from Jira and “Inicio Incidente” datetime custom field, for the correct filter in this view I need to select specific dates in “Inicio Incidente” to visualize the issues that wll be in this filter.

Tks for your help!

Hi,
Actually, you can filter the report by “Issues with Inicio Incidente > 0” and it would do the trick for the particular period.
Then remove this measure from the report and select “Issue inico incidente” in columns.

Martins / eazyBI