I have set visual cues to a set expression using the >= normal and <=limits
The visual cues are set to dates so in the Expression 'Last Order Date UK' I have the following:
Upper >=today()-90 Black
Lower <=today()-180 Red
This is all working well, but i want to add the same cues to highlight in colour to certain other expressions in the list.
so in the expression for a stock count for instance, i want to highlight the cell based on the other expression.
I have tried these, but they do nothing.
Only([Last Order Date UK])=today()-90
=[Last Order Date UK]=today()-90
There is no expression error but the colouring does not occur.
Does anyone have any idea how to set a visual cue for an expression, based on another expression?
Thank you so much in advance.
Just wanted to sy thanks again, your example has led me to the required solution of;
if(Today()-90<= Only( [Last Order Date UK]),
if(Today()-180>= Only( [Last Order Date UK]),
if(Today()-90>= Only( [Last Order Date UK]),
Hi Again Chris,
I dont suppose you know how i can select in field a button to only show ALL data with [Last Order Date] >-90 days?
I am looking to only export to excel those dates coloured.
Can you filter on colour? i didnt think possible so my thinking was to make a button to select the data that is coloured by Expression (text colour).
I have tried select in field and Search string -=date(Today())-180>= but am getting no return.
Any help on this would be much appreciated.
If you want a permanent selection on the table, or at least on a copy of the table for that export you could use an extra column & dimension limit - sort of like I did here;