Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys, i have exp.
(
(
COUNT(DISTINCT
{<[Week Start]={"$(=MAX([Week Start]))"},[State]={'Closed'},WorkItemType={'Bug'}>}
ID)
-
COUNT(DISTINCT
{<[Week Start]={"$(=MIN([Week Start]))"},[State]={'Closed'},WorkItemType={'Bug'}>}
ID)
)
/
COUNT (DISTINCT[Week Start])
)
And what i want to achieve is to ignore selection when user select field [Week Start], [Week Start]= not working,
do you have any idea? probably because i use [Week Start] in set analysis ?
Resolve the issue,
[Week Start=]
was not working because i had calculated dimension date(floor(WeekStart), when i replace WeekStart instead of calc. dimension, that's works like a charm
can you try it with single quotes instead of double in the set analysis for WeekStart and if weekstart is a date field use date function in min and max $(=date(max(...))). i would split these into 3 expressions and see where it is failing to test.
Resolve the issue,
[Week Start=]
was not working because i had calculated dimension date(floor(WeekStart), when i replace WeekStart instead of calc. dimension, that's works like a charm