Skip to main content
Solved

As of Date for KPI

  • September 14, 2022
  • 5 replies
  • 662 views

Forum|alt.badge.img+1
  • Budding Pigmenteer

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?

Best answer by Benoit

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)

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'))

You can polish the formula to return the date format you want (MM/DD/YYYY or DD/MM/YYYY...)

 

And here is my KPI

 

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

 

 

 

View original
Did this topic help you find an answer to your question?

Benoit
Community Manager
Forum|alt.badge.img+13
  • Community Manager
  • September 15, 2022

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)

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'))

You can polish the formula to return the date format you want (MM/DD/YYYY or DD/MM/YYYY...)

 

And here is my KPI

 

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

 

 

 


  • Newly Minted Pigmenteer
  • December 6, 2022

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?

 


Forum|alt.badge.img+1
  • Newly Minted Pigmenteer
  • May 16, 2023

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


Keiran
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • May 16, 2023

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!


Chris
Forum|alt.badge.img+14
  • Keen Learner
  • October 27, 2023

Hey everyone! 

Iโ€™ve got some good news, you can now use the date data type for KPIs! Check it out

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings