SPLIT_PART MAQL equivalent?


  • Graeme Carmichael
    Community Moderator


    We cannot create custom attributes in GoodData. The best I can suggest is to create custom metrics based on the text value of your custom field. You can do that by using the LIKE and ILIKE operators and searching for the separator characters.

    You can check the example here

  • Dan Ross
    Community Moderator

    Hey David,

    It doesn't look like it, here's the supported expressions in GoodData: https://help.gooddata.com/display/doc/MAQL+Expression+Reference

    You might be able to work around this by making a metric for each main feature to aggregate all the subfeatures into a single count.

    ex: select # tickets where feature in (mainfeature-subfeature1, mainfeature-subfeature2) and then name the metric as mainfeature.

    You could have each one drill into the category if you needed a breakdown of the subfeatures after that. 


    Hope that helps


Please sign in to leave a comment.

Powered by Zendesk