Hi Guys,
I have a requirement for using a vizlib table to create an indicator based on month to month comparison
So there are two date fields, the actual_date that consists of the past two months, 09/20 and 08/20. Each month a new month is added but for now we only have these two months. Then we have manufactured date for the products. So we need to make make a table for products and their manufactured date, one based on latest actual_date and one based on prev actual_date. So the table for the previous actual_date would be like:
| Product | Manufactured Date |
| A | 4/16/18 |
| B | 2/5/17 |
| C | 3/14/16 |
and the table for the current actual_date would be like:
| Product | Manufactured Date |
| A | 1/16/15 |
| B | 5/9/18 |
| C | 3/14/16 |
So the table below would be the manufactured date of products based on previous vs current actual_date field. We are needing to create a indicator, just a background color on CURR to compare whether the manufactured date for a product in the current actual_date is sooner or later than the manufactured date the previous actual date
| Product | Manufactured Date (PREV) | Manufactured Date (CURR) |
| A | 4/16/18 | 1/16/15 |
| B | 2/5/17 | 5/9/18 |
| C | 3/14/16 | 3/14/16 |
However, the expression i've tried to use isn't working, I am only getting white background color. I had created two variables vCurrentMonth (max(actual_date)) for the current actual_date and vPreviousMonth (=Date(Monthstart(Date(Date#(Max(actual_date),'MM-YYYY'),'MM-YYYY'))-1,'MM/YY'))
for the previous actual_date and had created this expression:
if(only({<Actual_date={$(vCurrentMonth)}>}Manufactured_Date) > only({<Actual_Date={$(vPreviousMonth)}>}Manufactured_Date), Green(),
if(only({<Actual_date={$(vCurrentMonth)}>}Manufactured_Date) < only({<Actual_Date={$(vPreviousMonth)}>}Manufactured_Date), Red(), White()))
As mentioned I am only getting white background cells when that shouldn't be the case. What am I doing wrong?
