This is an annoying bug and we currently have no idea on how to solve it.
We have a data source from Snowflake with an issue from Jira and its several upper levels of hierarchy. While performing a count of issues we found some strange results, with a count significantly higher than expected. From here we have started testing, and created a simple table with:
Issue_type
Issue_key
count(distinct issue_key)
Given this, count(distinct should always be equal to 1, since we are grouping by issue_key as well. We have tried to use the count as a calculated field and apply the measure the the issue_key field as well. The results are way off with both methods. However, when I click on Show Underlying Data, the data is correct and a 1 is shown on the last column.
What can be possibly causing this? This seems like a bug, it is not the first time that it is happening, but we would like to know if there is a known cause, if it happened to someone else and what could be a solution here.
Best regards
LinkedIn
Twitter
