Hi there, I have an issue, and can't figure out how to accomplish this. I have written a Custom SQL query for pulling data about planned expenses and realized expenses. These are the columns: Department, Date, planed expenses and Realized expenses.
I need to visualize, how much a department has already spent, based on a date filter on a dashboard, in contrast to the planned expenses for the same department for q whole year.
I need to show, how much the department has money left for spending.
I ve made YoY, MoM visualizations, but can't get this one right:
