Canvas dropdown filter

[tims (Tim Schnell)]

Ok, so I think that you need to update your Costs query to be grouped by ConsumedService so that the value that you are passing in via filterColumn will actually have a corresponding column in the Costs query. If you visualize your Costs query as a datatable you will see that right now it is only returning the total sum not broken out by ConsumedService.

Here is a similar question that was posted a while back that may give you a better idea of some things to try.

Canvas dropdownfilter does not filter

I'm working on my first Canvas and want to show statistics about my payment brands in my shop, including a time filter and a payment brand filter: [payment_brands_canvas] Everything works as I want, except for the payment brands filter. After some fiddling, I did get to populate it correctly but when I select one of the payment brands, the chart is not filtered based on that brand (which is my goal) and throws an error (that is gone very quickly, so I had to record my actions to be able to se…