Hello everyone, I build a gannt chart and want to count the issues with start date, but as shown in the screenshot, when two components are written in the column Solution Train/Cluster, the numbers of the issues are counted for 2. I want to get only 1. And then, the sum of all the numbers are caculated totally, shown at the botton. How could I solve this problem? Thanks a lot
Best Regards
Qian
Did you try with the “Distinct formulas”?
Instead of using the “Issues created” you can use in your formula the “Issues created count” and it should solve your problem
Core Measures Distinct properties
Hi @Qian
If you filter this report by components, the issue is counted by all its components that are selected.
The @Nacho, in general, is right about the need for a distinct count count measure in such case.
However, in your case, you would need to use the distinct count measure for “Issues with start date,” which is not available by default. But you may create such a measure using advanced settings with SQL code that does exactly that.
Instruction to obtain this measure:
Find the ID for your custom field “Start date”: either in Jira or in eazyBI import options (you can see it when the mouse hovers the custom field in the Custom fields list). You will need this ID in the next step.
In eazyBI advanced settings, add the following settings; change NNNNN with the custom field ID. You can change the measure name as well, if you want to.
[jira.customfield_startdate_count]
name = "Issues with Start date count"
data_type = "integer"
measure = true
sql_expression = "CASE WHEN {{issue_with_customfield_NNNNN}} IS NOT NULL THEN {{issue_id}} END"
measures_table_name = "jira_issues_measures"
aggregator = "distinct-count"
When advanced settings are added, go to the import options, Custom fields tab, and find there the field “Issues with start date count” (or the name you used), select it for data import as a measure, and perform the import.
Use measure “Issues with start date count” in the report instead of the standard “Issues with start date” (find in Measures, Custom fields section).
The difference between the standard field and the distinct count measure you can see in my sample report:
Best,
Ilze, support@eazybi.com
Hi @Nacho , thanks for your reply, when “issues created count” is used, the gannt chart can not be shown correctly, if the “Years” are selected through the filter “Times”. Since all the JIRA Tickets were created in the year 2024. When the “Start Date” is given for the year 2020 to 2023, the data will not be shown in the gannt chart.
Hello @ilze.leite , I am greatly appreciated for your help and have following questions:
hello support@eazybi.com, could you please help me?Thanks
