I’m trying to make a graph for my IT department to track how many incoming help-desk tickets we get from each department. I have a filter set up so we can view this info for specific time periods, but I’m running into an issue with getting all of the departments displayed.
I have a bar graph to display all of the departments on the x-axis, with the y-axis showing how many tickets were submitted. But if, for example, the accounting department did not submit any tickets in the selected time period, then accounting will not show up on the graph at all since there is no data from them. I’m trying to find a way to have accounting still show on the x-axis with a value of 0. That way, all departments will show on the graph regardless of whether they have submitted any tickets or not.
The way I’ve been attempting to do it is by creating a parameter to select all of the department names from a drop-down list, and making a calculated field to list all of the selected departments so they will show up regardless of if they have any tickets or not. This is what my ifelse statement looks like:
ifelse(
in("Accounting",${Department_List}),"Accounting",
in("HR",${Department_List}),"HR",
in("Legal",${Department_List}),"Legal",
in("Sales",${Department_List}),"Sales",
"False")
However, this is only outputting the first department in the selected list, so my x-axis only has the one department. Is there another way I could make this method work, or is there a better method to accomplish what I’m trying to do?
