Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
i have an issue , creating segment of Product By Model_Size, And Quantity Sold..
i have to create buckets, on quantity, and price..
kindly look at attached sample..
if anyone could help me,
i will really appreciate it..
Many Thanks..
kindly ask me, i will explain in detail..'
i want to use dimension from Product Table. column name is Label, and want to see how much quantity and price sold on each bucket,
ANYONE PLEASE...!
Hello Israr,
Could you please elaborate a little bit about your requirement.
Thanks,
V.
There is clearly a cartesian product happenin in the sellout table. All the dimension have linear data.
Please correct the data model.
-Sundar
Here you go hope this helps
put your data in a pivot table.
Product and label dimensdion on quantity and price measures.
Regards
Andy
daer vishsaggi
if you see the data model, i have four tables, linked like below:
Bucket Table-->> Product Table --> Model Table -->> Transaction Table
i have range defined in the bucket table, minimum , maximum and label for the range.
i have to use Label from Bucket Table, as a dimension...
and i have to sum the quantity and Price from Transaction table,
and have to show the result in the pie chart on each bucket...
kindly have a look at bucket table...you will understand more...
many thanks
Dear Sundar,
i changed the data i removed the join from Bucket table into Product Table..
kindly have a look on data model now...
kindly explain me a bit more, how to correct data model, what is mean by All the dimension have linear data??
can you please...help on it??
see the new attachment please...
if you see, sum(sellout.qty) and sum(sellout.price) is repeating on each row in pivot table...
i want to see this result in pie chart, on each label column from bucket table...
many thanks