Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks!!.
I have the following problem and I was wondering if you guys could help me.
Have table that contains attributes of store and revenue of each store, for example:
Store
Sku
Quarter
Class Desc
Urban
Revenue
Would like to show a funnel chart with dimension as Revneue_Bucket and measure as Avg_Revenue/Store.
Dimension:
Revenue_Bucket column should contain below buckets (Top 10%,10-25%,25-45%,45-70%,Bottom 30%).
Measure:
Avg Revenue/Store
When I select any Revenue_Bucket it should contain all the stores belongs to the bucket based on the Revenue/Store and this should be dynamic.
After that will draw the graph between the Buckets vs Avg Revenue/Store
Below is the approach i thought,
1.By using inline command create Revnue_Bucket dimension
2. Calculate Revenue/Store
3. To the Revenue/Store column would like to calculate the percentiles(Ex:Top 10%,10-25%,25-45%,45-70%,Bottom 30%).(this part am not able to do)
4.Draw graph between Revenue_Bucket vs Avg_Revenue/Store
Sample Data:
Store,Sku,Quarter,Segment,Class Desc,Urban Desc,Revneue
651,A1,2,Suburban - White / Mixed,DILUTABLE CLEANER,SUBURBAN, 11
8636,A2,3,Urban - White / Mixed,DILUTABLE CLEANER,SUBURBAN, 90
11657,A3,3,Suburban - Hispanic,BATHROOM CLNR,SUBURBAN, 50
8051,A4,3,Urban - White / Mixed,BATHROOM CLNR,URBAN, 3
7652,A5,2,Rural - Hispanic,DILUTABLE CLEANER,RURAL, 7
9342,A6,3,Rural - White / Mixed,BATHROOM CLNR,RURAL, 30
2705,A1,3,Suburban - White / Mixed,DILUTABLE CLEANER,SUBURBAN, 27
11063,A7,1,Urban - African American,DILUTABLE CLEANER,SUBURBAN, 25
1091,A8,3,Urban - Hispanic,WIPE CLEANER,SUBURBAN, 3
6026,A9,3,Suburban - African American,SPRAY CLEANER,SUBURBAN, 8