I've currently got a view I'm building out for some data management and want to highlight/change the background color of cells which fit the criteria for "bad values", based on dates.
This is currently where my YAML lies. I've tried searching through the Celonis Documentation and haven't found anything in regards to comparing dates. I've also tried searching for YAML documentation, but I haven't found anything which satisfies what I"m looking for.
Best answer by abhishek.chatu14
Hi Matt,
There is a way to achieve this... and this is what you need to do
Now I used a date like 1996-11-21, now if the following data type is date and you do not give any format you should see something like this.
This is the format that Celonis wants you to input,not sure what this format is called but that is what Celonis will identify. In your case i.e. 1735689600000
This is what I am getting from the above comparator
Hope this helps!
Hi,
That comparator statement is not working? It seems it can do a work - as general rule, dynamic color change is quite limited in the business views.
Best Regards,
Mateusz Dudek
+4Hi Matt,
There is a way to achieve this... and this is what you need to do
Now I used a date like 1996-11-21, now if the following data type is date and you do not give any format you should see something like this.
This is the format that Celonis wants you to input,not sure what this format is called but that is what Celonis will identify. In your case i.e. 1735689600000
This is what I am getting from the above comparator
Hope this helps!
Hi Matt,
There is a way to achieve this... and this is what you need to do
Now I used a date like 1996-11-21, now if the following data type is date and you do not give any format you should see something like this.
This is the format that Celonis wants you to input,not sure what this format is called but that is what Celonis will identify. In your case i.e. 1735689600000
This is what I am getting from the above comparator
Hope this helps!
@Abhishek Chaturvedi Thank you! This did exactly what I was hoping for.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
