We have an index created with Fields viz. Product, leads. Now we want to add another column to it which is opportunity. But there will be cases when we have leads but not opportunity AND there will be cases when we have opportunity but no leads. There will be cases when we have both.
I want to show in one chart as Product and average of leads. In another chart we want to show Product and opportunity. If we select a product which doesn't have opportunity but have leads then Opportunity and Product chart should go blank but leads should be visible and vice versa. But this is not happening when we select a product which is having opportunity and no leads it is not showing even opportunity and leads chart. Kindly help in this regard do we have to create new index for leads and product or same index if there is any method.
Thanks & Regards