Date Range

[Pomna]

Hello,

I need help with date range and percentage. Below is my code and the results but I get a blank in the range.

Count({$<[Canonical Date]={'<$(=MonthStart(Today()))'},
[Status Name]=-{'Closed','DONE','No Further Action'}> +
<[Date Created]={'<$(=MonthStart(Today()))'},
[Date Closed] = {'>=$(=MonthStart(Today()))'}> }DISTINCT [Issue ID])/

Count(TOTAL{$<[Canonical Date]={'<$(=MonthStart(Today()))'},
[Status Name]=-{'Closed','DONE','No Further Action'}> +
<[Date Created]={'<$(=MonthStart(Today()))'},
[Date Closed] = {'>=$(=MonthStart(Today()))'}> }DISTINCT [Issue ID])

Below is the result and the blank in the day range circled in red which is my issue. Thank you

[JordyWegman]

Hi Pomna,

Do you maybe have some data that is in the QVF?

Jordy

Climber

[Pomna]

what do you mean. Please explain

[JordyWegman]

In order to help you, I need to know what kind of data you have. Can you maybe publish the application (QVF) ?

Jordy

Climber

[Pomna]

sorry I cannot share data but I was hoping to get possible scenarios that can cause this which would help me figure how to fix it.

[JordyWegman]

Then you need to dive a bit deeper into the data. You probably have a dimension, based on the dates that don't have an allocated range.

Try to find the rows in your data that associate with this.

Jordy

Climber