Challenges I am having when creating a Pareto graph

Nemo1 — Fri, 15 Nov 2024 21:03:34 GMT

Hello everyone,

I have just asked the same question but explaining the issue with my own words (english is not my first language, so it is not that easy for me to be clear).

I asked ChatGPT to help me be a litle bit clearer. Here is the following:

Graph Description: I want to create a graph, specifically a Pareto chart, that categorizes cities based on their percentage contribution to total sales (%Acc Sales).
Categorization Criteria: I plan to classify cities into three categories:

Category 1: The top 10% of cities with the highest sales.
Category 2: The next 20% of cities after the top 10%.
Category 3: The remaining cities (approximately 70%).
Data Organization:

The x-axis will represent cities sorted from highest to lowest sales (descending order).
The y-axis will represent the cumulative percentage of sales (%Acc Sales).

Challenges:

The x-axis sorting is showing the Cities in a descending order of sales, but you cannot see the separation between the categories (1,2 and 3 respectivally). I am failing at representing the boundaries between the three categories on the graph.

Specific Requests:

I want to add lines on the graph to indicate where each category starts on the x-axis.
Additionally, you'd like to label these lines to show the percentage of total sales each category represents

Here is how my graph looks like right now:

here is want i want to have:

thanks everyone in advance. i love this community.

Re: Challenges I am having when creating a Pareto graph

LRuCelver — Tue, 20 Feb 2024 13:10:59 GMT

Here is the data and all expressions used:

Data:

Data: NoConcatenate Load Chr(RecNo() + Ord('A') - 1) as City, Rand() * Rand() * Rand() * 1000 as Sales AutoGenerate 26;

Dimension:

=Aggr(Dual(City, Rank(Sum(Sales))), City)

Measure:

=RangeSum(Above(Sum(Sales), 0, RowNo())) / Sum(total Sales)

Dimension reference lines:

=Ceil(Count(distinct City) * 0.1) // Replace 0.1 with whatever percentage you want

Measure reference lines:

=Sum(Aggr(If(Rank(Sum(Sales)) <= Ceil(Count(distinct total City) * 0.1), Sum(Sales)), City)) / Sum(total Sales) // Replace 0.1 with whatever percentage you want

I hope it helps.

topic Challenges I am having when creating a Pareto graph in App Development

Challenges I am having when creating a Pareto graph

Re: Challenges I am having when creating a Pareto graph