how to get specific data from a table based on condition and then create chart

[Rupesh]

how to get specific data from a table based on condition and then create chart

 

i have one table containing multiple columns, out of those columns there are two columns i.e. Forecast and Actual value however Forecast dependency on another column i.e. Qtr = Current Qtr and Actual should be total Booked Amount column

[Kurumi]

Hi @Rupesh - you may use a SELECT statement and use it in your chat. For more information, you can check this link: https://howto.caspio.com/function-reference/#:~:text=Vary-,Select,-Returns a results