Line chart compare PY no need to show last week

[panwipa2528]

I have line chart as attach file, it's compare PY sale.
How should I do if I don't need to show week 52 .

[tresesco]

May be use calculated dimension.

=If(Week<52, Week)

[raman_rastogi]

Panwipa

You can restrict Week 52 from your dimension

EX- If(Week<>52,Week)

And Suppress Null values

Raman

[tresesco · Accepted solution]

Or, if your 'last week' is not really last week in the week field but based on data availability, you might use set analysis in the expressions. For specific help, try to share a sample qvw.

[panwipa2528]

Thank you

[panwipa2528]

Thank you