[Request]: Report on First Level of Dropdown only

1 댓글

  • Graeme Carmichael
    Community Moderator


    Sorry to say that there is no text matching conditions in GoodData. So you cannot say WHERE Category BEGINS 'Top Level::'

    Instead, you need to hard code each into your custom metric. For example:

    SELECT #Tickets where category IN (toplevel1::Item1,toplevel1::Item2,toplevel1::Item3)

    If you are going to use this same classification in many metrics, it may be better to create a metric like this:

    Metric Name: Check for Category Top Level 1

    SELECT CASE WHEN Category IN (toplevel1::Item1,toplevel1::Item2,toplevel1::Item3) THEN 1 ELSE 0 END

    Then in re-use this in other metrics.







댓글을 남기려면 로그인하세요.

Zendesk 제공