How could the some of the field values be excluded and how the name of values could be changed?

[#1]

Hey guys,

Are there any wasy to How exclude some field values, while using the rest of values of a field? Moreover, how could the name of values be changed?

Many thanks and regards!

[sudeepkm]

you can use Match or Exists functions in your script where clause to exclude certain values of your field.

For example:

load productid, Region where not match(Region,'EMEA','NAMR');

or you can load the Region names into a table and then use that field in Exists function in your where clause.

For example:

load productid, Region where not exists(MatchRegions, Region);

[#3]

But if I only want to exclude them when I design a chart, in other cases, perhaps I still need them?

[sudeepkm]

yes you can exclude the values in the Chart Dimension using a calculated dimension.

EDIT:

or in the chart expression using Set analysis

[#5]

The same method as you mentioned earlier?

[sudeepkm]

no it will be at the front end objects like charts not in script.

when you create a chart you can restrict the charts data as per a condition such as Region = EMEA and NAMR.

Can you also explain your requirement a little bit more then I can provide a sample.

[#7]

For example, if I have a field named component with value a, b, c, d, e, f, and g. I would like to only have value a, b, c, d in my field component to be a dimension in a line chart. How can I set the condition?

[sudeepkm]

please take a look at the example. I've created two charts in one you can restrict the values of a Field in the dimension and in another chart you can restrict the field values in expression using set analysis.

[#9]

Goto dimension instead of adding dimension use add calculated dimension available in right side give your condition there.

On what condition you want to select the values??