0
Regarding issues with editing the chart code
Hello everyone! Through studying the dashboard template Dashboard Template shared by Sotirios Zormpas, I have learned chart code. The following code already implements the display of accumulated data for a specific month. However, I still want to improve this feature. Thanks for your help! Thanks in advance.
- The time displayed in the chart does not show the complete days of the month, and I have set the code as follows(At the bottom.)..However, the view did not display correctly. Could you please tell me where the issue might be?
let fullDates := for i in range(1, 31) do
if i < 10 then "0" + text(i) else text(i) end
end;
let Timeperiod := (select 'Orders')[month(date('data')) = 5];
let onlytime := unique(Timeperiod.'data');
let cumulative := 0;
let AAAAAA := for luo1 in fullDates do
····
- I want to compare the cumulative data for April. How can I display them in a single chart? How should the code be adjusted?
let Timeperiod := (select 'Orders')[month(date('data')) = 5];
let onlytime := unique(Timeperiod.'data');
let cumulative := 0;
let AAAAAA := for luo1 in onlytime do
let Datadata := sum(Timeperiod['data' = luo1].'money');
cumulative := cumulative + Datadata;
{
name: luo1,
cumulative: cumulative
}
end;
let chartOptions04 := {
title: {
text: ""
},
tooltip: {
trigger: "axis"
},
legend: {
top: "name"
},
grid: {
left: "3%",
right: "4%",
bottom: "3%",
containLabel: true
},
dataset: [{
source: AAAAAA
}],
xAxis: {
type: "category",
encode: {
x: "name"
}
},
yAxis: {
type: "value",
axisLabel: {
interval: 0
}
},
series: [{
name: "name",
type: "line",
smooth: true,
seriesLayoutBy: "row",
stack: "total",
label: {
show: false
},
emphasis: {
focus: "series"
},
encode: {
x: "name",
y: "cumulative"
}
}]
};
3 replies
-
I used AI to write the following code. It can work! But there are still some small issues. That is, for some months and dates, there is no data. However, the data lines still fill up from the 1st to the 31st.For example, there is data from the 1st to the 5th and from the 10th to the 20th. Can it be displayed at intervals?
@let fixedDates := range(1, 32); let monthsToCompare := [6, 5, 4]; let allMonthsData := for month in monthsToCompare do let monthData := ((select '订单出库')[month(date('开始')) = month and year(date('开始')) = year(today())] order by number('开始')); let cumulativeTotal := 0; let monthEntries := for day in fixedDates do let dailyTotal := sum(monthData[day(date('开始')) = day].'总价'); cumulativeTotal := cumulativeTotal + dailyTotal; { day: day, cumulativeBaijiu: cumulativeTotal, month: month } end; monthEntries end; let cumulativeData := for monthData in allMonthsData do for entry in monthData do entry.cumulativeBaijiu; entry.month end end; let chartOptions := { title: {}, tooltip: { trigger: "axis" }, legend: { top: "top" }, grid: { left: "3%", right: "4%", bottom: "3%", containLabel: true }, xAxis: { type: "category", data: fixedDates }, yAxis: { type: "value", axisLabel: { interval: 0 } }, series: for monthData in allMonthsData do { name: first(monthData).month + "月", type: "line", smooth: true, showSymbol: false, data: for XX in monthData do XX.cumulativeBaijiu end } end };
Content aside
- 1 mth agoLast active
- 3Replies
- 64Views
-
2
Following