How to realize the group by XBI y of django

problem description

how to implement the format group by XJ y in django

the environmental background of the problems and what methods you have tried

related codes

/ / Please paste the code text below (do not replace the code with pictures)
want to use cityid and pcbid as x, y
Pvdata.objects.filter (updatetime__date=date (year=year, month=month, day=day))\

        .values("pcbid", "cityid", "updatetime", "channelid").annotate(Avg("p"))

what result do you expect? What is the error message actually seen?

Mar.28,2021

. Values ('pcbid',' cityid') model do not set cityid as the primary key. I don't know why I can't find it in the django document.

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b3f999-2c4a2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b3f999-2c4a2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?