Bar chart by days opens brackets is not working

[ajdm2007]

Hello everyone, 

I'm working on a dashboard to evaluate the performance of my IT support team. Initially, I had built a more basic version, but it had several pages and didn't include a calendar table or any metrics.

I have to admit, I've run into some issues with the metric visualizations because my data table has several dates: `date_entered`, `date_responded`, and `date_resolved`. Since I need a single date to filter the data and tell the story, I used the COALESCE function to create a new column called `days_for_analisys`. This column lets me include tickets that haven't been resolved yet by treating them as if they were resolved today.

This approach is necessary because I have a column called `days_open`, which shows how many days a ticket has been open, but it's grouped into day ranges (0-7, 8-14, 15-21, 22-28, and more than 28 days).

The goal is to display a chart like this one:

 

It works fine when there are no filters, meaning when I disable the interactions. But as soon as I enable them, the visualization stops working and only shows the category for completed tickets instead of all the different ranges.

For example, in August, I have several open tickets, but when I look at the chart, only the completed ones are displayed. I created a bar chart with `days_open` on the X-axis and `count_id` on the Y-axis, but it only shows one bar for completed tickets and doesn't include the others. It should display the tickets open for 22-28 days and another bar for those open for more than 28 days.

 

 

 

I can’t figure out where the problem is coming from, and since I don’t know that, I’m not sure how to fix it. Any chance someone could guide me or give me a clue about what might be going on?

I can share you my calendar table code or sample data to look at or even the relationships between the different tables.

Thank so much, I really appreciate any advice.

[Ashish_Mathur]

Hi,

Share some data to work with and show the expected result.  Share data in a format that can be pasted in an MS Excel file.

[ajdm2007]

Hello @Ashish_Mathur 

There you go.

Sample Data

Thank you so much, 

[Ashish_Mathur]

Share the download link of the PBI file.  Ensure the visual is already there and show the problem clearly.

[ajdm2007]

Hello @Ashish_Mathur

There you go.

Visualization

Thank you so much

[Ashish_Mathur]

I see no relation at all between your question in the original post and the data in your file.

[ajdm2007]

Hello @Ashish_Mathur ,

I'm a bit confused, the sample file I sent you contains the raw data, the filters and metrics are inside the project. I wonder if you expect me to send you the project?

I'm sorry but I don't really understand what you expect me to send you.

Thank you again,