Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have dimensions and exression as below in bar chart
Dimension1: =IF(FiscalWeekSerial>=$(curFiscalWeekSeq)-4,FiscalWeek)
Dimension2: Staff
Expression: COUNT({<DateDue={'>$(=Today())'}>}DISTINCT(StudentID))
So, this will show the data as weeks on horizotal axes. s, it will show weeks as 31,32,33,34. Now we are under 34 fiscal week.
My user wants to see starting only from currentfiscalweek and continuing. i,e
34,35,36,37. Is that possible. I changed the dimension as below
IF(FiscalWeekSerial>$(curFiscalWeekSeq)-1,FiscalWeek)
and it is showing only week 34. But I need to show 34,35,36,37.
Is it possible? if so can anyone suggest me please.
Thanks.
How can I display the next following weeks
?
Dear Amelia,
If you want to show data for Previous 4 weeks starting from current week... you can use something like below...
SUM({<Week = {'<=$(=Week(Today())) > $(=Week(Today())-4) '}>}Sales)
If you want to show data for Next 4 weeks starting from current week... you can use something like below...
SUM({<Week = {'>=$(=Week(Today())) < $(=Week(Today())-4) '}>}Sales)
Thanks. I would need to show the weeks display on the horizotal axes. Is it possible. Can you please change my exression please.
I tried many ways but no luck Please any solution?
Use dimension as Week
Tick Suppress When Value is Null in Dimension Tab
and use my given expressions.
Thanks. I can not use SUM. I don't have issue with expression . Only the issue is with dimension. Is there any change do I need to make. Now I have another dimensin also.
Dim1:=IF(FiscalWeekSerial>=$(curFiscalWeekSeq)-4,FiscalWeek)
Dim2: Staff
Dim3: Department.
Actually I have to show how many students are in progress(overdue) with the weeks based on DateDue
Please any help as this is very very urgent to me