Hello,
We are looking to create a chart that allows us to filter issues if they have due dates. I’m running into the issue where I would like to have a page level dimension so folks can see the measures for issues that have a due date and also for all issues (with or without a due date).
I am not able to see “due date” as a custom field in the advanced settings when I import my data so am not sure where to go from here.
Thanks so much!
Hi,
Filtering of issues by a date custom field should be implemented using the measure created from the date. It is not possible to create another dimension for each date field.
For your case, you should use the standard measure “Issues with due date”. You can also use a custom formula to find the issues without a due date:
[Measures].[Issues created]
-
[Measures].[Issues with due date]
The formulas may need adjustments if you use the Time dimension in the report.
Kindly,
Janis, eazyBI support
Hi,
i am new to eazyBI and have the same wish to have the dueDate as dimension because i want to filter the dueDate by quarter.
I.e. i want to filter the data for Q4 2024 and Q1 2025.
I want some filter for dueDate like “this quarter and the next”.
Do you have a solution for this?
Kind regards
Michael
