Language: EN | DE | CZ | SK | CHN | JA

# BellaDati BellaDati User's Documentation Reports Using Formulas and scripts Formula Use Cases Creating Pareto Chart Creating Pareto Chart

## Key

• This line was removed.
• Formatting was changed.
Sv translation
language en

A Pareto chart is a type of chart that contains both a bar chart and a line chart. Individual values are represented in descending order by bars, and the cumulative percentage is represented by the line.

To create the Pareto chart in BellaDati, it is necessary to use a Combined chart and a formula indicator.

The Combined chart will use one drill-down on the x-axis.

Image Modified

To display the cumulative percentage, following formula needs to be used:

Code Block
```xVal=M_VALUE
xCumulative=0
xCount=0
xMember=memberValue('L_ATT')
xTotal=withoutDrillDown() {
M_VALUE
}
withoutDrillDown() {
eachMember('L_ATT') {
if (M_VALUE>=xVal) {
if (firstValue('L_ATT')==xMember) {
xCumulative=xCumulative+M_VALUE
xCount=1
}
else {
if (xCount==1) {
}
else {
xCumulative=xCumulative+M_VALUE
}
}
}
}
}
return xCumulative/xTotal*100```

The result:

Image Modified

Sv translation
language ja

パレート図は、棒グラフと折れ線グラフの両方を含むグラフの一種です。個々の値はバーで降順で表され、累積パーセンテージは線で表されます。

複合グラフでは、x軸に1つのドリルダウンが使用されます。

累積パーセンテージを表示するには、次の式を使用する必要があります:

Code Block
```xVal=M_VALUE
xCumulative=0
xCount=0
xMember=memberValue('L_ATT')
xTotal=withoutDrillDown() {
M_VALUE
}
withoutDrillDown() {
eachMember('L_ATT') {
if (M_VALUE>=xVal) {
if (firstValue('L_ATT')==xMember) {
xCumulative=xCumulative+M_VALUE
xCount=1
}
else {
if (xCount==1) {
}
else {
xCumulative=xCumulative+M_VALUE
}
}
}
}
}
return xCumulative/xTotal*100```

結果: