Hi everybody,
I am facing some issues trying to create a barchart on Lookerstudio.
I have a GSheets dataset where every row is a project and I have columns such as average monthly income, success probability (probability to win the project), and monthly income from that project (July 1st, 2023, August 1st, 2023, etc.)
The final outcome I would like to achieve is a bar chart showing expected revenue by time (e.g. in the next 4 months, next year, etc.). I imagine x-axis to be time (July 1st, 2023, August 1st, 2023, etc.) and y-axis to be expected income. I would then have a date range control to change the time interval to my liking and a drop-down list control with success probability.
I tried two approaches:
Any help would be greatly appreciated! I can attach spreadsheets or graphs if anything is not clear enough.