Showing data as day wise but dimension should be week

[nizamsha]

Hi All,

Kindly have a look at the excel file.i have day wise data its Based on the current month only

Here is the scenario Dimension should be week .and also i have 2 Expression 1st is the Net and 2nd is the Current its in the  Column RunRate .

Net Run Rate Data we should consider till the end of month but when comes to current run rate it should show up to today only

if i am in the 5 th day of nov it should show the avg for both the project A and B but when i click on the single project it should show the single project and if i   am on the 6th day i want to show the avg only for  both project similarly if i click on single project it should show the 6th  day in week one .but when comes to 8th day .in week one i should see the 7 th day data and in week 2 it should show 8th day data others week should be null and the week should be split by 7 days .w1 to w4 contain seven days each in week 5 remaining days ! !

Finally if its not under stable completed week should contain last day data on that particular week  and the current week data should  be today date  kindly help to resolve this one

NJ

[jolivares]

This kind of problems can be solved using a simple set analysis.  Try to create a simple QVW with your data post and then I can explain for you what to do in this case.

[nizamsha]

Hi

Here is the App as you asked

[jolivares]

I just take your expresion for Net and Current put the project_Name

=num(avg({$<RunRate={'Net Average Run Rate'}, Project_Name>}RunRate%),'#,##0.00%')

=num(Avg({$<RunRate={'CurrentM_Average'}, Project_Name>}RunRate%),'#,##0.00%')

Now no matter what project you choose, your expresion always show the whole result.

Check it..

[nizamsha]

No you Wrongly understand the logic i will show the output what i want

with out project Selection i want this output

Week ,Net    ,Gross

W1    ,14.71  ,8.65

W2    ,30.79  ,31.70

W3   ,40.40   ,33.72

when i click on project B i want this output

Week ,Net    ,Gross

W1    ,15.00  ,9.00

W2    ,32.30  ,33.30

W3   ,40.40   ,35.00

if goes to tomorrow W3 Net and gross will change even if i select the project or not even select the project and keep on going based on date

others week data should be null

[nizamsha]

i know through Aggr we can able to bring this  one .but i am missing something while going for aggr i cant identify what i was missing

[anlonghi2]

Nizam,

with your excel data the average of 14th day is 29.64% not 30.79 %: do you confirm ?

[anlonghi2]

Hi Nizam,

please look at attached qvw and let me know

Best regards

Andrea

[nizamsha]

Hi Anlonghi,

Most probably we are near to the answer the completed week should show the max of the day data for gross and net in that case net and gross is correct  for w1 and w2 but when comes to w3 it should show the current day data that mean 18th acording to ur QVW 18 th data is Net 42.0  Gross 32.45 when comes to tomorrow it should show tomorrow data

Regards

Nizam

[nizamsha]

Hi Anlonghi,

date 1 to 30  is for November (Always current Month)

and also i will date up to today date remaining week i wont show in  that case w1,w2,w3 will have data when comes to w4 and w5 it will be null.

Regards

Nizam