How to make a list of sum with related children, with condition

[Aurelien]

Hi AppSheet Community,

I have a question regarding an optimization I would like to make.
This is for a sandbox app, no urgence.

Context: Time tracking app, using quickchart.io for aggregating data per activity type.
Goal: I would like to find a better way to express the data list for the chart.
Please note: I’m aware of the chart features, I’m just experimenting
Current Table structure:

I currently get this:

With these virtual columns expressions:
[ChartImage]

ENCODEURL(
  CONCATENATE(
    "https://quickchart.io/chart/render/zm-e933be74-84a0-4501-8a40-5007ec396b97",
    "?title=","Semaine "& [Week_Num],
    "&labels=",[Chart_Label],
    "&data1=",[Chart_Data]
  )
)

[Chart_Label]
UNIQUE([Related Tasks][Activity_Type])

[Chart_Data]

UNIQUE(
  IF(ISNOTBLANK(INDEX([_THISROW].[Chart_Label],1)),
    LIST(
      SUM(
        SELECT(
          Tasks[Total_Hours],
          AND(
          	INDEX([_THISROW].[Chart_Label],1)=[Activity_Type],
          	**otherConditions**         )        )      )
    ),
    LIST("")
  )
  +
  IF(ISNOTBLANK(INDEX([_THISROW].[Chart_Label],2)),
    LIST(
      SUM(
        SELECT(
          Tasks[Total_Hours],
          AND(
          	INDEX([_THISROW].[Chart_Label],2)=[Activity_Type],
          	**otherConditions**             )        )      )    ),
    LIST("")
  )
  +
  (**etc**...)
)
-LIST("")

Big question, now:
Would there be a better way to proceed ?
I would like to express dynamically the [Chart_Data] expression, because here I’m limited.

• Let’s say I stick to 2 activities ==> current expression would do the job
• let’s say I have 5 activites ==> current expression is missing data

Thank you in advance for your help !

[Steve]

There’s really no significantly better approach that I can see.