Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
i wanted to show the last 6 weeks in a bar chart. My actual dimension is like this:
=Year(x)&'-'&Week(x1)
if(week(today()-42) <= week(x) and week (today()) >= week(x) , yoir_dimension , null())
then suppress null.
if(week(today()-42) <= week(x) and week (today()) >= week(x) , yoir_dimension , null())
then suppress null.