Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Micki
Creator
Creator

Ignore field selection in set expression

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 ?

1 Solution

Accepted Solutions
Micki
Creator
Creator
Author

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

View solution in original post

2 Replies
edwin
Master II
Master II

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.  

Micki
Creator
Creator
Author

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