Skip to main content
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!

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

Knowledge Model:

imageClassic Analysis:

image


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.


Reply