Forum Discussion
Filter Group By in Same table
- 7 years ago
Drag EmpName and ProjName on to a table visualisation.
Then drag TimeSheetDate on to the same table twice.
In the Values field well, click the dropdown on the first TimeSheetDate, choose Earliest.
Click the dropdown on the secondTimeSheetDate, choose Latest.
You can change the date format by choosing TimeSheetDate instead of Date Hierarchy from the same dropdown.
Drag EmpName and ProjName on to a table visualisation.
Then drag TimeSheetDate on to the same table twice.
In the Values field well, click the dropdown on the first TimeSheetDate, choose Earliest.
Click the dropdown on the secondTimeSheetDate, choose Latest.
You can change the date format by choosing TimeSheetDate instead of Date Hierarchy from the same dropdown.
Thanks for the trick :) it worked!