[Request]: Report on First Level of Dropdown only

1 コメント

  • Graeme Carmichael
    コメントアクション Permalink

    Jeff

    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.

     

     

     

     

     

    0

ログインしてコメントを残してください。

Powered by Zendesk