Hi, I am trying to create a visual with distinct count of ASIN for the top 80% sales within a shelf. It seems calculating the top 80% sales has to include the {asin} in the partition, but when I create the visual, I want to see it at the shelf level, but Quick Sight does not allow me to do that. I w…

Hi @jimmix Can you share the details of your calculated field to review and also show the fields selected for the visual that has the errors? Regards, Giri

Hi Giri, here are the calculated fields definitions: running_sum: runningSum(sum(Sales)/sumOver(sum(Sales),[Vertical, Category, Shelf]),[sum(Sales) DESC],[Vertical, Category, Shelf]) shelf_total: sumOver(sum(Sales), [Vertical, Category, Shelf]) # Top 80% ASIN: sumOver(ifelse(maxOver({running_sum},…

Hi @jimmix What if you bring in the ASIN field into the dimension and then hide it? Does it work? Regards, Giri

Hi Giri, That wouldn’t work because this would just leave duplicate rows at the shelf level (hiding the ASIN field does not make the table distinct) Kind regards, Jimmy

Hi @jimmix , It’s been awhile since last communication on this thread, were you able to find a work around or are you still in need of further assistance? If we do not hear back within the next 3 business days, I’ll close out this topic. Thank you!

Hi Brett, I still couldn’t find a work around, so some further assistance would be much appreciated. Kind regards, Jimmy

Sure, here is the link of the dashboard in the Arena view: Top 80% ASIN count at Shelf Level

Hi @jimmix , Thank you for creating an Arena view for me to look in to this further. After testing out various different scenarios though, I don’t believe this will be achievable due to the runningSum calculation creating too much nesting of aggregations. Since you’re using a LAC-W calc. on the run…

Hi @jimmix , It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post? If we do not hear back within the next 3 business days, I’ll close out this topic. Thank you!

Count of ASIN bringing top 80% of sales

Q&A

Brett December 3, 2024, 7:28pm 8

Hi @jimmix,
With the number of calculated fields you’re working with, this may be a lot easier to assist further if you were to create a duplicate of your analysis and upload to the Arena view.

Topic		Replies	Views
Order of a table Q&A analysis , formatting , quick-sight , calculations , Business-Intelligence-Engineer	1	24	January 21, 2025
How do i filter for top 10 ASINs for each segment according to shipment days DESC Q&A quick-sight , Business-Intelligence-Engineer	1	30	August 1, 2025
Create one bar graph where I want to plot top 5 and bottom 5 profit product? Q&A analysis , quick-sight , calculations	3	1183	November 30, 2022
MaxOver Top 10 filter within Calculated Field Q&A analysis , quick-sight , calculations	2	649	January 3, 2023
Customers percentage below 80% of total Amount Q&A analysis , feature-request , quick-sight , calculations	3	716	April 7, 2022

Count of ASIN bringing top 80% of sales

Related topics