Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello 🙂
Again one question about set analysis which is pretty tough currently for me ^^
I changed my set analysis to make it irrespective of any selections but it doesn't work as I expected.
( i changed the $ to a 1 )
because when I select anything, the numbers in the graph change, and if I have understood well, the numbers should not change otherwise it would be like if I used $ in the set analysis.
I don't understand why, if someone has any clues to show me the path ^^
My set analysis is
count({1<[date_1]={">=$(startMonthActual)"}>*<[date_1]={"<=$(endMonthAcual)"}>}[Person]
So if I select other date not in the boundary, the shown value is 0 and when the date is in the boundary, the value decreases as if it was a responsive set analysis.
Thanks a lot for reading !
HI @flo2
In order to avoid the selection , assign the {1} set analysis in both startMonthActual & endMonthAcual variables also.
Ex: startMonthActual = Min({1}Date)
count({1<[date_1]={">=$(startMonthActual)<=$(endMonthAcual)"}>}[Person]
edit : Thanks a lot, i think it works as you said, can you confirm me if it looks good to you ?
I had this variable :
=MonthEnd(today(),-1)
And i make it work now with set analysis as you said, =Min({1}MonthEnd(today(),-1))
And also for the variable monthStart i use the same set analysis =Min({1}MonthStart(today(),-1))
I use min in both cases because in all cases i am going to have just one value, so if use max or min it will be the same if i don't say trash
thanks
-----------------
Thanks a lot ! And sorry to ask a bit too much but i have hard times with set analysis 😁
I have the variable StartMonthActual with the folowing definition : =MonthStart(today(),1)
and if i have understood well i can't use function in set anlysis no... ? Maybe that's totally false what I say 😅
(i wonder because I have also a second variable i use for the same graph : =MonthStart(today(),2)
the goal is to have the month in two months )
and in the same archetype, i have variables to have the last 3 months.
What could i do to have MonthStart(today(),2) as variable as set analysis ?