Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a chart with the dimension: week number and some measures for each week. I want to see in chart, only the values for the last 4 weeks inclusive the week i select in filter. How can I do that? Thank you, Magdalena
try with:
only( {< Week = {">$(=Max(Week) - 4)<=$(=Max(Week))"} >} [value1] )
use set analysis like below:
ex. sum( {< Week = {">$(=Max(Week) - 4)"} >} Sales )
Hi Andrea,
Thank you, but is not working.
My dimension is: week
My measure is: only({<[week]=>}[value1])
and when I make measure how you said: only( {< Week = {">(Week - 4)"} >} [value1] ) the chart is null.
Thank you,
Magdalena
only( {< Week = {">$(=Max(Week) - 4)"} >} [value1] )
Hi, You are right! I was writing wrong! It is ok, but only when I am selecting this week it appears the last 4 weeks, but when I select other weeks appear all the previos weeks, inclusiv the current week. How can I modiffics the measure to appear just 4 weeks, indifferent what week i select? Thank you, Magdalena
try with:
only( {< Week = {">$(=Max(Week) - 4)<=$(=Max(Week))"} >} [value1] )
Thank you Andrea!! Magdalena