I have a date filed and I want to filter the table based on that but only filters the created date

Questions & Answers
1

I have a date field. And Iwhen I select Feb 2025 it only filters issues created in Feb 2025 but I want to filter the issues that customfield_xyz is Feb 2025. How can i filter time based on custom filed and not created date?

image
image1383Ă—703 72.1 KB

2

This might not be the smartest the way but it works in most cases.

The idea is to create a custom calculated member that will do a conditional check and see if date is in bound of selected time.

CASE
WHEN
DateCompare([Time].CurrentHierarchyMember.StartDate,[Measures].[Custom Time])<0 AND
DateCompare([Time].CurrentHierarchyMember.NextStartDate,[Measures].[Custom Time])>0
THEN [Measures].[Custom Time]
ELSE
NULL
END

3

Hi @iclalaslan,

In eazyBI, there is only one Time dimension you can use to filter and group data. The key element is predefined measure representing the issue count with the date field.

For example, to filter issues by due date, you have to select the measure “Issue with due date” for the report. Only issues with due dates in the selected Time period will have a numerical value in the report.

To filter by your custom date “Teslimat Date” field instead of the creation date, you need to:

  1. Add the measure “Issues with Teslimat Date” to your report columns.

  2. Click on the “Issues with Teslimat Date” column header and Filter rows that has value greater than 0. Issues with Teslimat Date > 0

  3. On pages, use “Time” dimension to filter report issues by Teslimat Date.

Please see the documentaiton for more details on how Time dimension works in eazyBI and how you can filter data in the repor: Time dimension .

Best,

Zane / aupport@eazyBI.com

4

This worked perfectly thank you!