Skip to main content
Question

Hello everyone,I want to present a KPI using a custom format not available in the default format options.Is it possible to create custom formats somehow?I cannot change the KPI value because it must be used as KPI of a pivot table.Thks!

  • April 9, 2023
  • 2 replies
  • 5 views

Forum|alt.badge.img
Hello everyone, I want to present a KPI using a custom format not available in the default format options. Is it possible to create custom formats somehow? I cannot change the KPI value because it must be used as KPI of a pivot table. Thks!

2 replies

kailash.potha12
Level 10
Forum|alt.badge.img+6

Hi Farias, I think you can use this option to input custom format

Knowledge Model:

imageClassic Analysis:

image


Forum|alt.badge.img
  • Author
  • Level 1
  • April 10, 2023

Thks Kailash for your quick and gentle response :-)

 

Unfortunately the manual input of the format doesn't fit my requirements, because in my case I need to show a Unix timestamp in DD:HH:MM:SS format, but the DD part is the number of days since the start of the date in the timestamp, not the month day.

 

I could do it creating a function / procedure like we do in databases, but here I think it's not possible to to do something similar.

 

Excel deals with this scenario very well:

 

Excel timestamp format 

Thank you again.