Data format for 'Progress' visualisation?

I am trying to get a progress bar visualisation for a KPI. I am writing SQL to get two numbers, an actual and a target but the ‘progress’ option is greyed out and when i click it i get a green bar taking the first number as both the goal and target.

What is the ideal data input format for it?
Was unable to find this in the documentation.

I found the answer.
The progress visualisation needs only a number input and then the static goal has to be set from the settings icon after choosing this visualisation. This was not obvious to me.
The latest documentation doesn’t mention this at all and infact doesn’t even mention ‘progress’ as an visualization option. I would be up for updating the documentation if anyone can guide me how to?