Filter Heat Map by Date Range

Question

I have created a service call heat map showing count of calls based on department and hour of day. The heat map can be filtered by priority by selecting high, medium, low or all in a drop-down list. I would like to add the capability for the user to filter the heat map by selecting a date range (start date - end date) as well. I have been unable to accomplish this. 

I have included a sample for review here.

Thank you for your assistance.

Ron

Answer 1

Replaced Slicer with TimeLine.

GUI. No typing.

Same links.

Answer 2

Hi Ron,

I'm writing to follow up on this thread. If you still need assistance, please feel free to leave a reply.

Best regards,

Madoc

Answer 3

Excel 365 Pro Plus with PowerPivot and Power Query (aka Get & Transform)

Select priority(ies), date(s) and hour(s) with Slicers.

With heat map.

No formulas of any kind anywhere.

http://www.mediafire.com/file/3wghrh9xx2q34dk/11_19_19.xlsx/file

http://www.mediafire.com/file/4rmlgjz605cjdb9/11_19_19.pdf/file

Answer 4

Thanks for your reply,

I can select the between filter for the reported column, but that does not change the count in my heat map. I use a COUNTIFS statement for my heat map to function. Filtering on the source data does not change the count. I was hoping to filter like I did for priority level on the heat map sheet.

Thanks,

Ron

Answer 5

To:  RonA18

Re:  filter heat map

I took a look at your sample workbook.

It shows a scheduled start date column on a sheet separate from the heat map.

But I cannot  find an actual start date and a completion date schedule available.

An idea...

Add start date and completion date columns to whatever data you want to filter.

Convert the new columns and data to a Table (Ribbon | Insert (tab).

A Table has built in filter capability.

Filter by the Start column and then filter by the Completion column - that should do it?

'---

Excel programs (now free) at MediaFire...

http://www.mediafire.com/folder/lto3hbhyq0hcf/Documents