Hi everyone,
I am trying to display total hours spent in Calls and Avg calls duration on anything that could resamble a KPI box in a human readable format (HH:MM and MM:SS).
I have calculated fields converting from millisecond to the string format I need, taking into account the aggregation (sum for first metric, avg for second).
Though, I am unable to get the desired result:
If I use a table, then the KPI value is too small compared to the others and looks ugly.
No way to make it work inside a Insight type visualization
No way to make it work inside a Word Cloud type visualization.
As FYI, I have already read the discussion and and checked the QS Arena Analysis here with no results.
Hi @ErikG ,
Yes it did. It’s a pity that the text size cannot be the same as the others KPIs (Medium), as it seems that the markdown headers value can be either Small or Big (using KPIs text values). Anyway, no big deal, but definetely something the Quicksight Team might want to address:
Time formatting in KPIs
Text size more aligned to other visuals in Insights
Much more flexibilitty in row text size in Tables.
@ErikG
I also want to reference this analysis and visualize in my own dashboard. However, I am not able to see the underlying analysis in the above community dashboard you have shared.
Any help will be highly appreciated.
Thanks
Thanks for the swift response.
can you explain how you have displayed it in the KPI?
For giving you some background. I have a column which has values in seconds
I am first doing a average of all the values in the column getting a single value and converting it into a hour and minutes separately. Check below formula
We can convert it into a decimal which is working fine displaying in HH.MM but we want HH:MM.
This can also give me a string which we can display as HH:MM but we are not able to display it in KPI
Any help would be appreciated.
