Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I have this field [Hour]: 1, 2, 3,....22,23,24.
How is it possible to convert to 12-hour format with adding AM or PM if it's dimension(without properties format):
=if ([Timestamp (Hour)] = 1,'1 AM',
if ([Timestamp (Hour)] = 2,'2 AM',
if ([Timestamp (Hour)] = 3,'3 AM',
if ([Timestamp (Hour)] = 4,'4 AM',
if ([Timestamp (Hour)] = 5,'5 AM',
if ([Timestamp (Hour)] = 6,'6 AM',
if ([Timestamp (Hour)] = 7,'7 AM',
if ([Timestamp (Hour)] = 8,'8 AM',
if ([Timestamp (Hour)] = 9,'9 AM',
if ([Timestamp (Hour)] = 10,'10 AM',
if ([Timestamp (Hour)] = 11,'11 AM',
if ([Timestamp (Hour)] = 12,'12 PM',
if ([Timestamp (Hour)] = 13,'1 PM',
if ([Timestamp (Hour)] = 14,'2 PM',
if ([Timestamp (Hour)] = 15,'3 PM',
if ([Timestamp (Hour)] = 16,'4 PM',
if ([Timestamp (Hour)] = 17,'5 PM',
if ([Timestamp (Hour)] = 18,'6 PM',
if ([Timestamp (Hour)] = 19,'7 PM',
if ([Timestamp (Hour)] = 20,'8 PM',
if ([Timestamp (Hour)] = 21,'9 PM',
if ([Timestamp (Hour)] = 22,'10 PM',
if ([Timestamp (Hour)] = 23,'11 PM',
if ([Timestamp (Hour)] = 0,'12 AM'