Is it possible to have indicators based on Date? I have a table with a series of entries that show the last time a location sent in their royalties. I would like to have the row turn orange if they are one month late, and red if they are two months or more late.
Date
Votes
1 comment
-
Hi Dale,
This is possible. You would not use the date column directly, you would create a formula for the calculation for months overdue. You would add a hidden data column to do a calculation on how many months late the date is. Your indicator would be based on this hidden column and could change colour based on a time range.
I'll include a link to our indicators document https://support.klipfolio.com/hc/en-us/articles/215545898-How-to-use-Indicators
If you get stuck, please reach out to the support team for help!
- Meggan
Please sign in to leave a comment.