Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
aditi_haldule
Contributor III
Contributor III

How to add set analysis for dimensions

Hi,

I have some products on X axis (dimension)and their values on Y axis on a bar chart. I want to show all the values on X axis and exclude one product- so that on X axis all the products are show except for 1 which I dont want to show. Is there a way I can do that? Maybe set analysis?

1 Solution

Accepted Solutions
salonicdk28
Creator II
Creator II

you need to write your expression exactly same as below screenshot, with no space in "-= "and {'NC'}

salonicdk28_1-1615551581556.png

 

View solution in original post

12 Replies
salonicdk28
Creator II
Creator II

Try this in your dimension

=Aggr(Only({<Product-={'X'}>}Product),Value)

It would be great if you would provide actual dimensions and how you want to see them

aditi_haldule
Contributor III
Contributor III
Author

Hi, Actually there are some type of fibres/cables (dimensions)on X axis out of which I dont want to show one of them(with the name 'NC') in the bar chart. These wire types come under the column name 'Product'. Y axis shows the number of sales which is the measure. So what exactly should be put into fx of the dimension to not include this 'NC' which comes under column 'Product' in my bar chart?

salonicdk28
Creator II
Creator II

Use this as dimension 

Aggr(Only({<Product-={'NC'}>}Product),Sales)

aditi_haldule
Contributor III
Contributor III
Author

This is giving me the exact total of the sales of the cables except for the NC but it shows only 1 bar in the bar chart. (So only 1 bar chart that represents total sales except NC sales) .I actually want to show all the remaining bars except for the NC channel bar on the X axis.

salonicdk28
Creator II
Creator II

Can you share me the screenshot of your expression once 

aditi_haldule
Contributor III
Contributor III
Author

here product target conversion  column refers to products.

aditi_haldule
Contributor III
Contributor III
Author

this is giving me 1 bar chart that's showing 67 sales which is the total sales of remaining products/channels except for the NC

NitinK7
Specialist
Specialist

may be you enter extra space before NC   -  ' NC'

NitinK7_0-1615551088020.png

 

salonicdk28
Creator II
Creator II

you need to write your expression exactly same as below screenshot, with no space in "-= "and {'NC'}

salonicdk28_1-1615551581556.png