topic Re: Set Analysis Month -1 in Management & Governance

Set Analysis Month -1

zied_ahmed1 — Thu, 11 Jan 2018 11:29:18 GMT

Hello I have this set analysis like Month to date :

DateCal=,Year=,Month=,Quarter=,

DateCal={">=$(=MonthStart(max(DateCal)))<=$(=date(max(DateCal)))"}

I would like now to do Month to date -1 (if i select April 2017 i will have March 2017 )

Thanks for help

omarbensalem‌

Re: Set Analysis Month -1

swuehl — Thu, 11 Jan 2018 11:32:17 GMT

Month=,Quarter=,

DateCal={">=$(=MonthStart(max(DateCal),-1))<$(=MonthStart(max(DateCal)))"}

Re: Set Analysis Month -1

OmarBenSalem — Thu, 11 Jan 2018 11:34:27 GMT

It should be sthing like:

DateCal={">=$(=MonthStart(max(DateCal),-1))<$(=MonthStart(max(DateCal)))"}

DateCal={">=$(=MonthStart(max(DateCal),-1))<=$(=MonthEnd(max(DateCal),-1))"}

Re: Set Analysis Month -1

zied_ahmed1 — Thu, 11 Jan 2018 11:37:42 GMT

Hello Stefan,

I used this but it doesn't work

Re: Set Analysis Month -1

OmarBenSalem — Thu, 11 Jan 2018 11:42:49 GMT

the try :

DateCal={">= $(=addmonths(MonthStart(max(DateCal)),-1))<= $(=addmonths(date(max(DateCal)),-1))"}

Re: Set Analysis Month -1

sunny_talwar — Thu, 11 Jan 2018 12:28:45 GMT

What date range and format do you see when you add this to a KPI object?

='>=' & MonthStart(Max(DateCal),-1) & '<' & MonthStart(Max(DateCal))

Do you see the >=03/01/2017<04/01/2017 when you select April? and also in the format of your field DateCal?

Re: Set Analysis Month -1

zied_ahmed1 — Thu, 11 Jan 2018 13:43:32 GMT

Hello,

Thanks for all,

I don't know why when i try this in text object :

='>=' & MonthStart(Max(DateCal),-1) & '<' & MonthStart(Max(DateCal))

I have the good result :

But when i put it in variable and i use it in the set analysis like that :

I have this :

Re: Set Analysis Month -1

sunny_talwar — Thu, 11 Jan 2018 13:45:58 GMT

Try with this variable

DateCal = {"$(='>=' & MonthStart(Max(DateCal),-1) & '<' & MonthStart(Max(DateCal)))"}

Re: Set Analysis Month -1

zied_ahmed1 — Thu, 11 Jan 2018 13:54:30 GMT

I used this variable :

DateCal = {"$(='>=' & MonthStart(Max(DateCal),-1) & '<' & MonthStart(Max(DateCal)))"}

and this set analysis and I have 0 :

count({<$(var)>}Docs)

Re: Set Analysis Month -1

sunny_talwar — Thu, 11 Jan 2018 13:55:45 GMT

Can you share an image of chart where you use this expression. Make sure to not label the expression... I would like to see how this get's expanded in the label

Re: Set Analysis Month -1

zied_ahmed1 — Thu, 11 Jan 2018 14:03:13 GMT

DOS_REF_EXTERNE is my kpi

Re: Set Analysis Month -1

sunny_talwar — Thu, 11 Jan 2018 14:05:53 GMT

My bad, I wanted to see it in a table object...

Re: Set Analysis Month -1

zied_ahmed1 — Thu, 11 Jan 2018 14:10:27 GMT

Hello,

I find the problem i need to add year=,month = in the variable :

Year=,Month=,DateCal = {"$(='>=' & MonthStart(Max(DateCal),-1) & '<' & MonthStart(Max(DateCal)))"}

Re: Set Analysis Month -1

sunny_talwar — Thu, 11 Jan 2018 14:23:53 GMT

Bro you are a genius, I sometime wonder why do you even seek help as you are able to solve your issue 9 out of 10 times

Re: Set Analysis Month -1

zied_ahmed1 — Thu, 11 Jan 2018 14:27:24 GMT

Hahaha yes sometimes i find my problem