Correct representation of the top values in % within Barchart
Hi guys, my data table looks like this:
Supplier
delivered on time
total quantity
Key figure1
Key figure2
Supplier 1
114.162
171.863
20,78%
66,4%
Supplier 2
69.702
100.002
12,69%
69,7%
Supplier 3
19.990
22.241
3,64%
89,9%
Supplier 4
17.295
21.580
3,15%
80,1%
Supplier 5
12.982
13.082
2,36%
99,2%
Key figure 2 shows me the correct calculation: Calculation does look like this is column 1: delivered on time through column 2: total quantity, but if I include this calculation in the bar chart, I get the values as in column 1: Key Figure 1, which is wrong.
what do i have to change in the calculation to have the values from column Key figure 2: inside the bar chart. i tried to solve this case with aggregation but i get wrong values. I get the wrong values if I also select in the setting to display the top 5 suppliers.
Does anyone have an idea how to solve something like this?
Would be helpful if you could supply the app in question - clearly something is not right with whatever formula / data you're using but it's hard to guess what based on just the information in this post.
Hi Or/ Master II, thank you for your feedback. If I didn't explain so clearly, here's my problem:
to calculate the key figure 2 i: i am using this expression: delivered on time / total quantity = key figure 2,
but if i put this expression in bar chart then i have these results (see key figure 1), i tried to use the function: aggregation, but i didn't achive the expected results.
therefore i want just to know: which expression i must create to get the figures (like in key figure2)
I hope I have been able to explain clearly. Thanks a lot for your time and help
Unfortunately, this still isn't helpful without knowing what "delivered on time" and "total quantity" are. Ultimately, if you're dividing one thing by another, the result is always going to be consistent and math doesn't change, so the issue is either with the underlying formulas for one or both of those two things, or the issue is with the data structure.
