I have column chart as shown in image and have made it drillable.
How do I filter records to show corresponding months records?
Discussion posts and replies are publicly visible
Make a second Interface object that has the relevant rule input(s) that you need to render the "corresponding months records" and then when you have that working, in your above chart when you click on a given bar - say 'Apr' - then save the corresponding value(s) that match the rule input(s) to your new Interface into the local variable(s) that you will map to those rule input(s).
I have this code :
filters: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: 'recordType!DDE Invoice Data.date', operator: "between", value: {date(2000,local!selectedmonth,1),date(2100,local!selectedmonth,30)}, ) }, ignoreFiltersWithEmptyValues: true, ),
Error :
Could not cast from Map to Number (Integer). Details: CastInvalidCould not cast from Map to Number (Integer). Details: CastInvalid