KPI to populate strings

Q&A
,
1

i am trying to display something like below in Minutes:Seconds but KPI visual is not accepting as the calculated column has logic like Minutes : Seconds (string expression). The only option i have is table visual to display this single value in string format but it doesn’t look great. any other visual can support this in quicksight?

image
image261×132 5.6 KB

2

Hi @Shivananda,

In terms of a similar layout, the two options I can think of would either be exploring insight narratives, as that allows you to use field values paired with natural language. Or the other option would be overlapping text boxes in free-form layout. However that would also require the use of a parameter to handle the time.

One last thing you could try, although the formatting may vary, would be to find a ticking clock url that you can then add in using custom visual content.

3

Thank you for response, The value i am trying to populate here is from a calculated column and Insight visual wouldn’t allow this unless its a parameter. ticking clock url also wouldn’t work as there is a calculation behind this time. looks like having the value displayed in Table visual only the option.?

4

Hi @Shivananda,

If it’s coming from a calculated field then yes, that may be your only option as you’ll have to utilize some type of visual to include calc. field. I suppose you could test out the word cloud visual as well and apply filters so that it’s down to one larger value.

5

Hi @Shivananda,

Just checking back in since we haven’t heard from you in a bit. Were you able to see Brett’s reply and/or find a solution yourself in the meantime? If you still have any additional questions related to your initial post, please feel free to share them. Otherwise, any update you’re able to provide within the next 3 business days would be helpful for the community.

Thanks!

6

Hi @Shivananda,

Since we haven’t received any further updates from you, I’ll treat this inquiry as complete for now. If you have any additional questions, feel free to create a new post in the community and link this discussion for context.

Thank you!