Display values on a scatter chart without aggregating and hard-coded filter

[#1]

Doubt 1 :In the attached qvw, I created a qvw. Here I want to display the dots at each record, that is one dot for one record. I have used the dimension as bmc_desc, so

the final dots are aggregated at the bmc level. I have used expressions as sum(incremental_sales) and sum(imcremental profit), but I want to show the

incremental sales and incremental_profit of each dot. But nothing is displayed when I use just "incremental_sales" as the expression.

Please suggest how to display dots at each record level and then all records belonging to a single bmc have one color.

data_context

sub_category_code

sub_category_desc

family_code

week_id

week_num

promo_sales

baseline_sales

incremental_sales

incremental_profit

discount

avg_nbr_of_baskets

baseline_nbr_of_baskets

basket_size_impact

incremental_traffic

net_basket_impact

quadrant

weekly_amt

bmc_desc

avg_basket_size

baseline_basket_size

brand

vendor_name

promo_code

promo_start_date

promo_end_date

supplement

press

tv

radio

smart_shopper

instore

																												0
-Super-All	G120201	RICE	11852	201146	46	18788.79	16913.97	-468.747	-2595.42	0.243324	301	223.8628	-155.87	77.13719	12562.26	4	8079.1	KIDS CEREALS	615.2133	771.083637	KELLOGG'S	Kellogg Company SA (Pty) Ltd	NULL	00:00.0	00:00.0	1	0	0
I-Super-All	G120201	RICE	11852	201147	47	15233.55	15495.99	-2162.55	-3633.04	0.243466	246.6667	210.244	-84.941	36.42267	5856.349	4	6550.45	KIDS CEREALS	651.0967	736.037626	KELLOGG'S	Kellogg Company SA (Pty) Ltd	NULL	00:00.0	00:00.0	1	0	0

Doubt 2 : Is there a way to hard-code the filter. For example in the qvw attached, you can see a filter DAta context which has three values. Is there a way to remove that list box and by default set the filter condition to All

[#2]

May be this would help. Check out the expression background and set analysis for your questions respectively.

Regards,

Kiran Rokkam.

Included attachment

[#3]

HI Kiran,

Thanks fr the reply.

CAn you please explain the process?

Why did you add so many dimensions? Can you please take me through it

[#4]

Also, can you help me on the second question(doubt)??

[#5]

If you expand the expressions you can see background color options. You can use them to specify the color of the bubbles.

Regards,

Kiran Rokkam.

[#6]

I added these dimensions as you wanted a bubble for each record. Keep only the ones you need (just to show how it works).

Regards,

Kiran Rokkam.

[#7]

Hi Kiran,

All-All	G120201	COOKING OILS	11852	201146	46	5881.71	5507.957	-359.885	-1355.820286	0.000214	83.66667	75.79664	-17.3506	7.870029	4022.524	4	4603.746	KIDS CEREALS	678.2233	695.573884	KELLOGG'S	Kellogg Company SA (Pty) Ltd	NULL	00:00.0	00:00.0	1	0	0	0	0	0
All-All	G120201	COOKING OILS	11852	201147	47	5135.24	5313.199	-818.488	-2043.165873	0.000125	70.33333	76.98693	-29.1778	-6.653596	-6619.85	4	4019.443	KIDS CEREALS	657.32	686.497823	KELLOGG'S	Kellogg Company SA (Pty) Ltd	NULL	00:00.0	00:00.0	1	0	0	0	0	0
All-All	G120201	COOKING OILS	11852	201148	48	6221.06	7750.665	-2305.57	-1550.718239	0.000108	89	117.8203	-96.1857	-28.820294	-38086.7	4	4869.376	KIDS CEREALS	928.3067	1024.49234	KELLOGG'S	Kellogg Company SA (Pty) Ltd	NULL	00:00.0	00:00.0	1	0	0	0	0	0

Here in this qvw, in the expression I gave sum({<data_context={"All-All"}>}incremental_sales)

So that it will select only All-All records and it indeed does select those records for which datacontext = All-All. But when you click cooking oils, you can see two dots : family and kids cereals. I went to the data source and found two bmc_desc : kids cereals and family. The above are the three records I found for kids cereals, but on the chart I am able to plot only one dot. As per the requirement I want three dots one for each of the above.

I think it is showing only one dot because we are using sum in the expression and hence it is aggregating the results. Is there a way to show all the records. Also, what is the exact purpose of dimensions?

thanks!

[#8]

Uday,

The no. of dots depends on the no. of distict values combinations of the dimension. For the selections made the dimensions (bmc_desc, sub_category_code and sub_category_desc) has only two distinct combinations (you can check that by adding these three fields into a table box). Add necessary dimensions to increase the dots. ( Personally i dont recommed this).

Regards,

Kiran Rokkam.

[#9]

So in a way, if we give the unique of tat table as dimensions then we ll get the unique rows.

Am I right?

[#10]

Yes. So clarify the business requirements and start with QVW. One more recommendation is alias fields name so that users can understand them. Keep only the necessary fields and remove the rest (its saves lot of time) as its easy to add fields anytime.

Kiran.