topic Re: How to add set analysis for dimensions in App Development

How to add set analysis for dimensions

aditi_haldule — Fri, 12 Mar 2021 08:34:25 GMT

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?

Re: How to add set analysis for dimensions

salonicdk28 — Fri, 12 Mar 2021 10:31:30 GMT

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

Re: How to add set analysis for dimensions

aditi_haldule — Fri, 12 Mar 2021 11:01:42 GMT

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?

Re: How to add set analysis for dimensions

salonicdk28 — Fri, 12 Mar 2021 11:04:48 GMT

Use this as dimension

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

Re: How to add set analysis for dimensions

aditi_haldule — Fri, 12 Mar 2021 11:29:25 GMT

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.

Re: How to add set analysis for dimensions

salonicdk28 — Fri, 12 Mar 2021 11:43:04 GMT

Can you share me the screenshot of your expression once

Re: How to add set analysis for dimensions

aditi_haldule — Fri, 12 Mar 2021 11:54:22 GMT

here product target conversion column refers to products.

Re: How to add set analysis for dimensions

aditi_haldule — Fri, 12 Mar 2021 11:56:46 GMT

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

Re: How to add set analysis for dimensions

NitinK7 — Fri, 12 Mar 2021 12:11:43 GMT

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

Re: How to add set analysis for dimensions

salonicdk28 — Fri, 12 Mar 2021 12:20:35 GMT

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

Re: How to add set analysis for dimensions

aditi_haldule — Fri, 12 Mar 2021 12:24:57 GMT

Hi, yes that was a mistake. Now I'm able to see 4 bars on X axis which dont include NC but one of them comes in gray without a label. But their total still gives me the exact value of sales except NC. I'll figure out about that one gray bar in the bar chart hopefully. Thanks a lot! 🙂

Re: How to add set analysis for dimensions

salonicdk28 — Fri, 12 Mar 2021 12:31:10 GMT

That grey bar is of null values, if you uncheck that option from your dimension then that will also go away

If you get your answer then please accept that as solution

Thanks

Re: How to add set analysis for dimensions

aditi_haldule — Fri, 12 Mar 2021 12:36:39 GMT

Yes perfect! Done!

Thank you so much 🙂