Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi, try filtering by date in set analysis: [Date]={">=$(=Date(AddMonths(Max(Date),-2)))<=$(=Date(Max(Date)))"}
We are having data upto dec month , if i applied above one it is showing upto week 53 (DEC month)
Kindly advice!
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)