切换主题
一、通用代码
一、数据去重
1、时间去重
python
const allDate=[]
data.value.forEach(item=>{
let time=item.dateTime.split(" ")[0]
if(!allDate.includes(time)) allDate.push(time)
})
const sortedDate = allDate.sort((a,b)=>new Date(a)-new Date(b))
二、数据转换
1、
js
const res=data.value.map(item=>{
return {
name:item.serviceType,
value:item.userId
}
})
2、过滤年份,过滤月份
js
const data = this.res.filter(item => {
let time = item.date1.split("/")[0]
return time === this.op
}).sort((a, b) => new Date(a.date1) - new Date(b.date1))
const month = []
data.forEach(item => {
let time = item.date1.split("/")[1]
if (!month.includes(time)) month.push(time)
})
const result = month.map(item => {
let volume = 0
let count = 0
data.forEach(item2 => {
let time = +(item2.date1.split("/")[1])
if (time === +item) {
volume += item2.volume
count++
}
})
return {
name: item,
value:
+((volume / count).toFixed(2))
}
})