How to keep a graph unchanged when selecting a calculated field?

[MichalSa]

Hi

I have a line graph and the X-axis is a calculated week :          Week (Date)

Is there a way to lock the graph so when I choose a week it won't change and filter?

I can do it with [Date] by adding it to the set analysis but not with Week (Date).

unfortunately I don't have access to the script and can't created variables so need to do it through the set analysis.

Is that possible?

Thanks!!

Michal  😎

[uroboros]

Hi@MichalSa ,

When you add some field in the set analysis without a set of data, with it, you will ignore fields selections.

Something like this:

Sum({<Date>}value)

[MichalSa]

Thanks for replying!

It works for 'Date' but not for any manipulation on Date - in my case Week(Date)

[uroboros]

Sure, make a Week field as a master calendar, later you add it into set analysis and ignore it.