Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
josem_lopezp
Contributor
Contributor

How to create a graphic with calculated dimensions

Hi everybody,

I'm trying to create a graphic with a calculated dimension. The objective of this dimension is to make a filter inside a field and then operate the resulting value inside a expression.

For example, i have a table that contains 4 possible status of an item (01, 02, 03, 04) but i only want to work with the items which status is for example: 01 and 02.  Which is the correct syntax to archive this goal? 

Thank you in advance

1 Reply
pradosh_thakur
Master II
Master II

In the script

Where match(status,01,02)

in epression
if(status=01 or status =02, dimension,null()) and then supress null

or

use set analysis with {<status={01,02}>}
Learning never stops.