I have a bar chart that should show the current month and the previous 13 months.
On the x-axis I make a concatenation of year and month (the written month, not in number). This is my fx:
=if (GetSelectedCount(AÑO)=0 AND FECHA>=(Monthstart(Addmonths(TODAY(),-12))) AND FECHA<=TODAY(),
AÑO& ' ' &(MONTH(MakeDate([AÑO],MES))),
if(GetSelectedCount(DMES)<>0 AND FECHA>=vLimiteMenor AND FECHA<=vLimiteSuperior,
AÑO&' '&IF(LEN(MES)=1,'0'&MES,MES)
))
- *DMES means written month
- *MES means numer of month
- *vLimiteMenor means =(Monthstart(Addmonths(DATE(FLOOR(Timestamp#(MAX(FECHA))),'DD/MM/YYYY'),-12)))
- *vLimiteSuperior means =DATE(FLOOR(Timestamp#(MAX(FECHA))),'DD/MM/YYYY')
When I filter, I also need to view the filtered month and the previous 13 months, so I used different methods: alternate states, method {1}... BUT WHEN FILTER, the order of concatenation does not work well.
Can someone help me? I do not know what I'm doing wrong