topic Re: Week of 2 month view in linegraph in App Development

Week of 2 month view in linegraph

Lakshminarayanan_J — Fri, 11 Nov 2022 12:06:04 GMT

Hi All,

I have an requirement, where i need to display weeks for 2 month on data instead of one week for one month which we are showing currently,

need to display weeks for 2 month data and above is the expression which we used to display one month data , when i try to modify it it is not displaying the result as expected .

Expression used for 1 week data display:

FOR OCT Month data:

if(id=1,
rangesum( above(num(sum({<[ Year]={'$(vMaxYear)'}, [Date]={"<=$(vTodayNew)"},$(vEXPFunction)
[Month Num]={$(=max([Month Num])-2)}>}FilesQTY),'#,##0'),0,rowno())))

Weeks display in graph:

Kindly do the needful!

@rubenmarin @Lech_Miszkiewicz @SwathiPulagam @Ruggero_Piccoli @AronC @sunny2

Re: Week of 2 month view in linegraph

rubenmarin — Fri, 11 Nov 2022 12:15:53 GMT

Hi, try filtering by date in set analysis: [Date]={">=$(=Date(AddMonths(Max(Date),-2)))<=$(=Date(Max(Date)))"}

Re: Week of 2 month view in linegraph

Lakshminarayanan_J — Mon, 14 Nov 2022 07:00:11 GMT

@rubenmarin

We are having data upto dec month , if i applied above one it is showing upto week 53 (DEC month)

Kindly advice!

Re: Week of 2 month view in linegraph

rubenmarin — Mon, 14 Nov 2022 07:21:27 GMT

If that happens is because the Date field has values until the week 53, different options:

- Check why there are dates for week 53 and correct it

-Use Today() instead of Max(Date)

- Instead of Max(Date) use a variable calculated as you need, like =RangeMin(Today(), Max(Date)) or =Max({<Amount={"*"}>} Date)