I’m trying to query the percentage of a value per another column I have, creating the query
SELECT percentage(count(*), where result = 'SUCCESS') FROM SyntheticCheck since '2019-10-01 04:00:00' UNTIL '2019-10-31 23:59:59' FACET TIP_Crn_Resource_Type limit max
The problem is that the column TIP_Crn_Resource_Type have different upper/lower cases of the same word, so I want to combine them, so it would be something like
SELECT percentage(count(*), where result = 'SUCCESS') FROM SyntheticCheck since '2019-10-01 04:00:00' UNTIL '2019-10-31 23:59:59' FACET lcase(TIP_Crn_Resource_Type) limit max
but there isn’t an option to do that, and it’s returning the values being case sensitive. How can I make my FACETs values to be case insensitive or any other suggestion that would group same words?
New Relic Edit
- I want this too
- I have more info to share (reply below)
- I have a solution for this
We take feature ideas seriously and our product managers review every one when plotting their roadmaps. However, there is no guarantee this feature will be implemented. This post ensures the idea is put on the table and discussed though. So please vote and share your extra details with our team.