Filter on Scripted Custom Field

[briantaylor]

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

[daina.tupule]

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:

Aggregate(
  Except(
    [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 / support@eazybi.com