
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Expression in Visual Cue
Hi All,
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
Normal Orange
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
and
=[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.
Daniel
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
You can add a formula through the expressions tab to the Text Color of the expression, so something like;
Cheers,
Chris.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
You can add a formula through the expressions tab to the Text Color of the expression, so something like;
Cheers,
Chris.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks so much Chris,
I will give this a go and feedback.
Daniel

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Just wanted to sy thanks again, your example has led me to the required solution of;
<90 Black
>90 Orange
>180 Red
if(Today()-90<= Only( [Last Order Date UK]),
RGB(0,0,0),
if(Today()-180>= Only( [Last Order Date UK]),
rgb(255,26,26),
if(Today()-90>= Only( [Last Order Date UK]),
rgb(250,131,26),
)
)
)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Thanks again
Daniel


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
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;
Cheers,
Chris.
