Hi Team,
I am currently looking to get bps split for one of the column buckets at week . The way operational team currently does is missed units for that bucket / total submitted for given week. i.e let’s say missed units MOQ bucket is 10,000 units for week 36 and total submitted for week 36 is 200,000. The BPS split would be 10,000/200,000 * 10^4. Is there a way to have this kind of calculation in quick sight? Any insights would be great.
Hello @parthprj !
You should be able to do this by using the following calculated field:
({missed_units} / {total_submitted_units}) * 10000
Then apply this to a visual that like a table or bar chart and use your date field aggregated to week in the x-axis or dimension field well.
Do I have to create a separate cal field for total submitted units ?
Hey @parthprj !
If that is not currently a field you would need to create it for this calculation to work. I was working on the assumption that submitted units was a field in your dataset.
I have qty submitted. I am looking for is to calculate CTM(Contribution to Miss) and it is calculated by each component sum of missed to total sum of submitted for that particular week. I tried doing what you recommended and it shows me error showing and aggreation and non aggregated value cannot be used in calculated field together. Do you know if we have any other way to calculate this?
Hello @parthprj !
Can you share an anonymized view of a few rows from your dataset so that I can better understand what your data looks like? That will help get around the calculation errors.
You could also create an arena:
Hello @parthprj !
Are you able to share a view of your dataset or create an arena link?
can try this ?
using table calculation function
sum(missed_units)/sumOver(sum(total_submitted_units),[])
1 Like