Hi, Currently, we have a measure that shows a count in #. We can also show it in %. But we didn’t find any way to show both the count in # and % (through the hover for example). Any suggestions ?

Hi Laura, currently we do not support this functionality where through the “hover” details pop-up it would show values in reports broken down by multiple mathematical functions, for example: percentage, count, AVG I will be happy to mark this as product feedback on your behalf. But I would like also recommend that you follow our Release Notes below to see what new functionality and features that will be coming to our Cloud platform soon: https://community.gooddata.com/product-updates

Hi Laura, As my colleague mentioned, it is not currently possible out of the box. However, there is a possible workaround which uses some MAQL and Metric formatting magic. You could use something like this:

select round({metric/metric1}/(select {metric/metric1} by all other)*100)+ {metric/metric1}/1000000

It calculates percentage as integer part and raw number as in decimal digits (as millionths). For example

50.000123

Metric format:

#,##0\% ({{{.000001|1000000|#,##0}}})

will display such number as

50% (123)

That's great ! Thanks a lot, I will try that 🙂