Hi I am trying to make a chart for a work orders layout.
I have a customer, they can have multiple work orders. this also shows price and a create date
I want two graphs one that shows all work orders and filters them by the year in create date, which means i have to get the last 4 numbers in create date.
Second graph is one that shows a chart of all sales by Customer.
Any help will be greatly appreciated