Hi @RJF61,
Thanks for the clarification! In this case, I expect that we will have to manually sum the individual columns and add the totals to an array. This array can then be displayed based on a specific column order (example 2) or descendingly based on value (example 1 - mimicking your screenshot). Both examples can be seen in the screenshot below. My charts were based on 6 columns, but I have provided 9 column placeholders in my code examples.
Example 1 - Line Chart displaying the columns descendingly based on value
Adjust the Line Chart Items property to the following code:
With(
{
//Fetch list in memory; adjust list name
wList: ListName
},
With(
{
wTotalSorted:Sort(
[
//Adjust column names
Sum(wList, Number1),
Sum(wList, Number2),
Sum(wList, Number3),
Sum(wList, Number4),
Sum(wList, Number5),
Sum(wList, Number6),
Sum(wList, Number7),
Sum(wList, Number8),
Sum(wList, Number9)
],
//Sort descendingly based on the total Value
Value,
SortOrder.Descending
)
},
ForAll(
Sequence(CountRows(wTotalSorted)),
//Add a text index column (will serve as label on the line chart)
{
Index:Text(Value),
Total:Index(wTotalSorted,Value).Value
}
)
)
)
This should result in the following Labels & Series1 values:
Example 2 - Line Chart displaying the columns in a predefined order
In this case we will add a Column Name field which will be used as chart label. The order in which you define the table rows will define the chart order. Adjust the Items property to the following code:
With(
{
//Fetch List in memory; adjust list name
wList: ListName
},
[
//Adjust column and colName parameters accordingly
{Total:Sum(wList, Number1),ColName:"Number 1"},
{Total:Sum(wList, Number2),ColName:"Number 2"},
{Total:Sum(wList, Number3),ColName:"Number 3"},
{Total:Sum(wList, Number4),ColName:"Number 4"},
{Total:Sum(wList, Number5),ColName:"Number 5"},
{Total:Sum(wList, Number6),ColName:"Number 6"},
{Total:Sum(wList, Number7),ColName:"Number 7"},
{Total:Sum(wList, Number8),ColName:"Number 8"},
{Total:Sum(wList, Number9),ColName:"Number 9"}
]
)
The Labels and Series1 properties should look as follows:
If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.
Thanks!
