topic Last 4 weeks variable issue in App Development

Last 4 weeks variable issue

benoitgochel — Tue, 03 Jul 2018 09:19:03 GMT

Hi all,

I'm trying to use a "last 4 weeks" variable but i'm encoutering issues with syntax I think.

I've tried this :

num(SUM({<[WeekNumber]={">$(=$(vMaxYearWeekID)-4)<=$(=$(vMaxYearWeekID))"}>}[Invent.Qty]))

My MaxYearWeekID variable looks like this :

=max( {1} YearWeekId)

What am I doing wrong?

Thank you in advance for the help.

Best regards,

Re: Last 4 weeks variable issue

YoussefBelloum — Tue, 03 Jul 2018 09:24:17 GMT

Hi,

the approach is ok, variable ok, expression ok, what do you see on the chart ?

Re: Last 4 weeks variable issue

benoitgochel — Tue, 03 Jul 2018 09:27:43 GMT

The value displayed is 0.

But when I put the "YearWeekID" field in a filter pane and select the last 4 weeks, I get a good value.

Re: Last 4 weeks variable issue

YoussefBelloum — Tue, 03 Jul 2018 09:31:53 GMT

do you have all the weeks on your data ?

example:

Measure, Week

100,1

200,2

120,3

210,4

340,5

145,6

125,7

574,8

195,9

354,10

165,11

==> here all weeks are available, you will see 4 lines as expected on the graph

or yo don't have all the weeks, like this:

Measure, Week

100,1

200,2

120,3

210,4

340,5

145,6

276,7

310,9

174,11

==> here week 8 and week 10 are missing.. so using your expression, you will only see two lines on the graph

Re: Last 4 weeks variable issue

benoitgochel — Tue, 03 Jul 2018 09:36:25 GMT

I do have all the weeks, numbers from 1 to 813.

And when I pick manualy the weeks 813 - 812 - 811 - 810, I see a result in my KPI.

With production KPI like :

num(SUM([Invent.Qty]))

Re: Last 4 weeks variable issue

YoussefBelloum — Tue, 03 Jul 2018 09:56:33 GMT

Would you be able to share sample app the see the issue ?

Re: Last 4 weeks variable issue

benoitgochel — Tue, 03 Jul 2018 10:24:56 GMT

The problem was somewhere else in my master calendar.

It is solved now.

Thank you for you time youssefbelloum‌

Re: Last 4 weeks variable issue

YoussefBelloum — Tue, 03 Jul 2018 11:29:47 GMT

no problem, good luck