<<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 |
---|---|
15 | |
11 | |
9 | |
7 | |
3 |