Hi
I wonder if it´s possible to have “Due Date” and "Start Date as an dimension?
As you can see on my example we created a project in Sep 2023 and we have set a Start date to 10 of June
Thanks in advance
I want to create a view for how many project that will start on specific days
Hey @Coachen
There can be only one date/date-time dimension in the eazyBI “Issues” cube, and there is already a “Time” dimension with that data type out-of-box.
Instead of importing your date picker Jira field as a separate dimension, it should be enough to import it as a measure and property , and then use the numerical measure "Issues with " 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
Martins / eazyBI support
Hi
A little background to me asking, I want to get a report for example with a special product when it is supposed to start without adding all our projects, I can’t do this
But if I use “Time” it works fine, but then gets up when the project is created. Sometimes it takes up to a year before a project starts and then this report is wrong.
Is there any other way to create such a report?
Hey @Coachen
What do you mean by “special product”?
Anyway, try selecting the measure “Issues with start date” and use it with any other dimension in the report. If you split this measure by “Time,” it will count issues where the start date belongs to a particular time period.
Then, you can filter the report by one or multiple projects when adding the “Project” dimension as a page filter or a “Product” dimension in a similar way.
Martins / eazyBI
