Forum Discussion
Solved
How to filter distinct count across multiple dates
Hi everybody I have a table with a List of opportunities, having dates when the first call of the opportunity took place, when the meeting took place, date of sending the offer, date of receiving...
Hi frieso,
Assume the source table like below:
You can open Query Editor, select columns Calls, Meetings, Offers and Contracts, then click Unpivot Columns button get the format below:
Apply the modification, go to the report, create a matrix and slicer visuals.
Best Regards,
Qiuyun Yu
First I suggest you unpivot your columns so you have a single date column and a type column (e.g. Call, meeting, contract etc). You can then use a timeline slicer on a calendar table joined to your single date column to filter the period you want. I guess a countrows of the data table will do it.