How do you create/show a date as a KPI. I want to show the last day of actuals for a data set and bring that into a board as a KPI. Is that possible?
As of Date for KPI
Hi Josh,
Today, we don’t support dates as KPIs.
But there is a workaround, that is to convert your date into text and display it as a KPI.
Here is my source date (format=date)
![](https://uploads-eu-west-1.insided.com/pigment-en/attachment/5b7b9fec-1d1b-4044-878e-cd36da896ffd.png)
Here is how I converted it (format=text)text(day('Last day of Actuals')) & "/" & text(month('Last day of Actuals')) & "/" & text(year('Last day of Actuals'))
![](https://uploads-eu-west-1.insided.com/pigment-en/attachment/38c052b0-39e0-4417-9293-6955c5ff2c29.png)
You can polish the formula to return the date format you want (MM/DD/YYYY or DD/MM/YYYY...)
And here is my KPI
![](https://uploads-eu-west-1.insided.com/pigment-en/attachment/d6de1339-5354-4cd4-9dc9-415c99de4934.png)
If you need this as a native feature, please use the Idea Community section to share this request and allow users to upvote it 😉
Hope it helps.
Best,
Benoit
Hello! I am trying to make the below screenshot into month day year .. but it errors once I do so because its trying to code the time - thoughts?
![](https://uploads-eu-west-1.insided.com/pigment-en/attachment/e8e378f6-0dec-4a54-813a-7e33d79b6997.png)
Hello! I also think it would be helpful to have the option to show a date as a KPI! I did it as Benoit proposed, converting it to text, but I will add it as an idea in the Community to have it at some point 😃 thanks
Hi Nora-Alloy,
I know you a while ago so hopefully you resolved that, but I thought I’d share a solution here in case anyone else comes across this;
DATE
(
ROUND( VALUE( mid(Transaction_List.Timestamp,1,4) ) )
, ROUND( VALUE( mid(Transaction_List.Timestamp,6,2) ) )
, ROUND( VALUE( mid(Transaction_List.Timestamp,9,2) ) )
)
Hopefully this helps!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.