Hello. My company is migrating to Windows 11. I created a small report that shows computers with Windows 11
Select Top 1000000 tblassets.AssetID,
tblassets.AssetName,
tsysassettypes.AssetTypename,
tsysassettypes.AssetTypeIcon10 As icon,
tblassets.IPAddress,
tblassets.Lastseen,
tblassets.Lasttried,
tblOperatingsystem.Version
From tblassets
Inner Join tblassetcustom On tblassets.AssetID = tblassetcustom.AssetID
Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
Inner Join tblOperatingsystem On
tblassets.AssetID = tblOperatingsystem.AssetID
Where Replace(tblOperatingsystem.Version, '.', '') >= 10022000 And
tblassetcustom.State = 1
And now I need to create a chart that would visually show the growth in the number of computers with Windows 11 by day
How can I do this?