How to subtract two queries in a pie chart

[bjgocraft]

Not 100% sure if this is what you’re trying to do, but maybe this helps:

Disk usage as percentage of used disk

Hi, while researching to achieve the same thing, I stumbled upon this post and want to share my solution: Go into the Transform data tab, press “+ Add transformation” and choose “Add field from calculation”. Choose the Mode “binary operation”. Then create the operation “total data size” minus “used data size”. You can give your new field an alias name like “free storage”: [Screenshot from 2024-10-25 11-39-42] Now you have three fields, but want to hide the field with the total size. This…