Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a countif expression where I want to count number of clients, but I want it to be fixed to a certain month. The current expression is :
count(if(InceptionDate,pkPolicyNumber))
I want this to be fixed to '2019-03-01', which is the inception date on a pie chart.
My Set analysis foundation is a bit shaky 🙂
Apologies, the script does work. The idea is for the object (pie chart) to remain on 2019-03-01, even when I select a different date. With the script you provided the pie chart changes with every date selection
it should work. Just a little syntax change...
Initial expression: Count( {<InceptionDate={'=$(=MakeDate(2019,3,1))'}>} ipkPolicyNumber)
Revised Expression: Count( {<InceptionDate={'=Date(MakeDate(2019,3,1),'YYYY-MM-DD')'}>} ipkPolicyNumber)