Set analysis and null/unknown

[robert_mika]

I'm creating chart with counts.

My dimension is

DayofWeek(Mon,Tue....)

If the data set is clean no gaps I can manipulate the values after Today() in normal way

They will changed the chart values accordingly

If I got bigger data set  (some of the row may have missing or null values ) the result stays almost the same with any of this configuration

=count({<CalendarDate= { "<=$(=Date(Today()-1, 'DD/MM/YYYY'))>$(=Date(Today()-20, 'DD/MM/YYYY'))"> }>}  id)

=count({<CalendarDate= { "<=$(=Date(Today()-1, 'DD/MM/YYYY'))>$=(Date(Today()-100, 'DD/MM/YYYY'))"> }>}  id)

=count({<CalendarDate= { "<=$(=Date(Today()-1, 'DD/MM/YYYY'))>$=(Date(Today() , 'DD/MM/YYYY'))"> }>}  id)

Which is always the the values (whole data set)

After playing with the numbers I see that the second condition (greater) is not evaluated.

What I'm missing here?

sunindia

?

[tresesco]

))>$=(Date(Today()-100 , .. is it a typo? If not , try like: ))>$(=Date((Today()-100),

[avinashelite]

try like this :

count({<CalendarDate={">=$(=Date(Today()-100,'MM/DD/YYYY'))<=$(=Date(Today()-1,'MM/DD/YYYY'))"}>}id)

[avinashelite]

I feel the conditions are not properly ended...try with the above format

[Kushal_Chawda]

try this

count({<CalendarDate= { "<=$(=Date(Today()-1, 'DD/MM/YYYY'))>$(=Date(Today()-20, 'DD/MM/YYYY'))" }>}  id)

=count({<CalendarDate= { "<=$(=Date(Today()-1, 'DD/MM/YYYY'))>$(=Date(Today()-100, 'DD/MM/YYYY'))" }>}  id)

=count({<CalendarDate= { "<=$(=Date(Today()-1, 'DD/MM/YYYY'))>$(=Date(Today() , 'DD/MM/YYYY'))"}>}  id)

[robert_mika]

Thank you all for input

The final solution is

=count({$<CalendarDate= { "<=$(=Date(Today()-10, 'DD/MM/YYYY'))>=$(=Date(Today()-20, 'DD/MM/YYYY'))" }>}  id)

tresesco‌

You were right - the equal sign

@Avinash R that did not work

kush14101987‌

that helps with the second >