week chart

[mshailaja]

i have week chart  from 1 to 52

if the dashboard refresh everyday i want to show the last weeks chart and last 7 days chart. How?

[Anonymous]

try below:

create weeknumber field

add set analysis to your expression.

For last week something like:

{<Weeknum = ,Weeknum={"=$(=Max(Weeknum)-1)"}>}

For last 7 days something like

{<datenum= ,datenum={">=$(=Max(datenum)-7) <= $(=Max(datenum))"}>}

Hope it helps. Or else if you can share a sample qvw it would be better.

[avinashelite]

Use Triggers .

Document properties > Triggers > On open > Add the action > select in Field >

Field name > Expression > =Week(Today())