Filter on Scripted Custom Field

I have a very simple table that is based on issue created and script field that tells number of time in a status. I want to capture only issues that are >0 in the scripted field.

“cube_name”: “Issues”,
“cube_reports”: [ {
“name”: “No. of times in Development “,
“folder_name”: “Test”,
“result_view”: “table”,
“definition”: {“columns”:{“dimensions”:[{“name”:“Measures”,“selected_set”:[”[Measures].[Issues created]”],“members”:[]}]},“rows”:{“dimensions”:[{“name”:“No. of Time in Status”,“selected_set”:["[No. of Time in Status].[No. of Time in Status].Members"],“members”:[],“bookmarked_members”:[]}]},“pages”:{“dimensions”:[]},“options”:{},“view”:{“current”:“table”,“maximized”:false,“table”:{}}}
} ],
“calculated_members”: []


Scripted Field Definition

You can define a calculated member in this dimension where you Aggregate all members of the No. of Time in Status level members except member with name 0.

For example, if you have a calculated member with the name No. of Time in Status > 0:

    [No. of Time in Status].[No. of Time in Status].Members,
    [No. of Time in Status].[0]

Then you can use this member in the reports or address in tuples to get a count of issues with those members:

([Measures].[Issues created],
 [No. of Time in Status].[No. of Time in Status > 0])

Daina /