topic Re: Exclude a specific dimension value from a chart in App Development

Exclude a specific dimension value from a chart

jerryr125 — Sun, 04 Aug 2019 16:14:28 GMT

i have a Dimension (daycat) with the following values (and only these values) :

Other

I would like to exclude “other” automatically without having the end user to filter it out.

thoughts ?? Jerry

Re: Exclude a specific dimension value from a chart

trdandamudi — Sun, 04 Aug 2019 17:29:33 GMT

Use the below expression as your dimension in the chart:

=If( Not [Type] Like 'Other' , [Type])

=If(Not WildMatch([Type], 'Other'), [Type])

You can use the below as expression:

Sum({<Type -={'Other'}>} Amount)

NOTE: Substitute your field name for 'Type'

Re: Exclude a specific dimension value from a chart

jerryr125 — Mon, 05 Aug 2019 12:21:55 GMT

hi - my 'Type' field is a master item dimension (DaysCatOrder). Does not work - any thoughts ? jerry

Re: Exclude a specific dimension value from a chart

trdandamudi — Mon, 05 Aug 2019 17:17:43 GMT

Can you please post a sample, so that I can see what I can do.

Thanks

Re: Exclude a specific dimension value from a chart

jerryr125 — Mon, 05 Aug 2019 20:15:06 GMT

Here is the Master Item Dimension expression:

MasterItem: DaysRR

=IF($(Days-Request-to-Requisition) >= 0 and $(Days-Request-to-Requisition) <= 3, '0-3',
IF($(Days-Request-to-Requisition) > 3 and $(Days-Request-to-Requisition) <= 5, '3+-5',
IF($(Days-Request-to-Requisition) > 5 and $(Days-Request-to-Requisition) <= 10, '5+-10',
IF($(Days-Request-to-Requisition) >= 10, '10+','NA'))))

Here is the results:

I do not want to show the NA bar

Re: Exclude a specific dimension value from a chart

trdandamudi — Tue, 06 Aug 2019 13:10:03 GMT

By excluding 'NA' in the expression should drop that bar automatically. Something link below:

Hope this helps.