- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
File Arrival Status
Hi,
I would like to show the file arrival status in my dashboard.
Let me explain in detail, I have 7 text boxes for weekdays (Sun, Mon,Tue…) and week dimension (53 weeks).
I want to show the status based on the week selection. I will choose only one week (I don't want to select the date). I would like to show the difference in text box’s background color, means that
Green color – File has been arrived on time
Orange color – File has been arrived with delay
Red color – File hasn’t been arrived for that day
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What is the table structure you have? Could you post sample data?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
My Table has the following colums (I have other columns also in the same table).
Week | Weekday | Date | File Arrival Status |
23 | 3 | 3-Jun-14 | On Time |
23 | 4 | 4-Jun-14 | Delay |
23 | 5 | 5-Jun-14 | On Time |
23 | 6 | 6-Jun-14 | On Time |
23 | 7 | 7-Jun-14 | Not Arrived |
24 | 1 | 8-Jun-14 | On Time |
24 | 2 | 9-Jun-14 | Not Arrived |
24 | 3 | 10-Jun-14 | On Time |
24 | 4 | 11-Jun-14 | On Time |
24 | 5 | 12-Jun-14 | Delay |
24 | 6 | 13-Jun-14 | On Time |
24 | 7 | 14-Jun-14 | On Time |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If you select a week - would you consider the latest date status as the week status? If so, try like:
=If(FirstSortedValue( Status, -Date) = 'On Time', green(), If(FirstSortedValue( Status, -Date) = 'Delay', RGB(250,140,100), Red()))