Expression to make chart static

[vikram_tulsiani]

Hello, 

I have a chart that I need to make static (does not change with selections made). This is the expression I am using but I cannot seem to fix it. Is there any way to use set analysis to keep it fixed?

=If(Week([Date Created On]) = Week(Today())-1,count([Material Description]))

The expression shows how many SKUs were created the past week.

Any help is greatly appreciated!

Thanks!

[CarlosAMonroy]

Hi,

You can use the modifier {1} in set analysis that will allow you to exclude every selection made by user.

=If(Week([Date Created On]) = Week(Today())-1,count( {1} [Material Description]))

Thanks,
Carlos M

[tincholiver]

count({1<WEEK={'>=$(=max(WEEK)-1)<$(=max(WEEK))'}>}[Material Description])