<<CONCATENATE(โhttps://quickchart.io/chart?c={type:โlineโ, data:{labels: [ โ โ,SUBSTITUTE(TEXT(SORT(Select(Table[Date],AND([_THISROW].[TID]=[TID],[Select]="1")),true)), " , " , " โ , โ โ),โ โ ], datasets:[{label:โoneโ,data:[โ,Select(Table[count],AND([_THISROW].[TID]=[TID],[Select]="1")),โ],borderColor:โgreenโ}]}}")>> I can view the chart in the application using the above formula with vc, but I cannot transfer the chart as pdf on the template in google documents, what can I do?
How should I sort here? I want to fetch the data that corresponds to the date, but I couldn't sort it correctly.
User | Count |
---|---|
16 | |
10 | |
10 | |
8 | |
3 |