Customize legends in a bar chart

Hello lbendlin 

Using this formula, I created a calculated column in my data model called days_for_analysis. The reason for this is that the COALESCE function helps me include tickets that haven’t been resolved yet, treating them as if they were resolved today. The best part is that when I change the main filter for the months, the values in the other visuals stay consistent.

Now, let’s talk about the open tickets. After adding the column and checking August, I’ve got several open tickets.

Check out the table:

So, I created a new bar chart where I put days_open on the X-axis and count_id on the Y-axis, but it's still only showing me one bar for the completed tickets and not including the others. I need a bar for those between 22 and 28 days and another for those over 28 days.

Basically, the goal of this chart is to show the user looking at the report how many tickets we have open for the month they’re checking.

I feel like I’m getting closer to solving the issue, and it’s all thanks to your guidance. What do you think?

What I want to show in this project is the performance of my help desk team. I did one before, but it was super basic and has like 6 pages; now I want to create something more professional and managerial.

Thanks for the time you’ve spent helping me out.

I hope to keep counting on your support!