When I change the type of a custom field to Dimension, it is displayed in my report as follows: 2024-11-04T00:00:00.000+0100, but i need only year, month and day. Thank you
Hi @Gabika
Do I understand correctly that you want to import a data picker custom field into eazyBI and use it in the reports to count issues by this date?
There can only be one date/date-time dimension in the eazyBI “Issues” cube, and there is already a Time dimension with that data type out-of-the-box. Similarly, in the real world, we have one calendar, and you refer to different events in it.
Instead of importing your date picker Jira field as a separate dimension, import it as a measure and property, and then use the numerical measure “Issues with date picker field name” together with the “Time” dimension members.
When using the “Time” dimension with that numerical measure, eazyBI would count the issues where your date picker field value belongs to the selected/displayed period.
See also this video on how to use the “Time” dimension with different numerical measures in eazyBI:
https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports/time-dimension
Best,
IlzeLA, suppor@eazybi.com