I need to do a revenue by week bar chart, where the revenue is categorised by department to show a stack bar chart and where the user can filter by one or more departments.
The problem I have is that 'Department' isn't actually a field, therefore I can't simply add it as a 2nd dimension.
Each Department is defined by certain DESKS and SECTORS
I have been able to do a set analysis for each expression, which gives me a stacked bar chart but the issue is that I have no DEPARTMENT picklist my users can filter by if the only want one departments revenue figures displayed.
I thought about have one expression in the chart and then defining each department with a bookmark and having those bookmarks available to the user as an object on the page, but this doesn't enable the user to select multiple departments.
The best way is to create the Department field in the script so you can use it as a dimension in your chart. Or perhaps you can try this approach: Users can map/group dimensions at run-time!
