Value in Chart - conditional

[QFanatic]

hi guys

PFA

On the chart - if a Weekday falls on a Sunday, I dont want to display 'N/A' - I want to display the word 'Sunday' - is that possible? Since I dont have WEEKDAY as a dimension in the chart - what would the expression look like?

If not - I can highlight the cell in red for instance.

Thank you

[rubenmarin · Accepted solution]

Hi, in example for 1st column you can add:

=If(Only({<PERIODID = {$(=Max(PERIODID)-1)}>} WEEKDAY)='Sun', 'Sunday', [Expression_as_it_is_now])

[QFanatic]

Thank you