I want to show percentage value from my different applications (Client, Server) into one column, I have written following NRQL for the same.
“select percentage(uniquecount(sessionID), where “some condition and app is clientname”) + percentage(count(“some another count”), where “some condition and app is serverappname”), where ) as ‘Percentage of count’ from AwsLambdaInvocation, pageaction facet application”
But using above condition my values are coming as,
Application | Percentage of count
App1 | 0%
App2 | 67%
and if I use , instead of + then it showing correct answer but in two columns:
Application |percentage | Percentage of count
App1 | 46% |0%
App2 | 0% | 67%
will it be possible to show above in one column? Thanks in advance for your support.
Thanks & regards,