I have a table with column Domain (Text), Date (Date), Time Range (Text) and Number of User Login (int).
The Number of User Login will aggregate in a bar chart by date. But it won't aggregate by Domain when i put it in table with slicer of date. The output is by domain and by time range. What has gone wrong here?
Solved! Go to Solution.
@rajendran, yes, it should be and I have tested yesterday and it was doing fine. But the table has changed when i opened it today. So I deleted the column in queries and undo the delete process and it has returned to normal now.
Sorry that there was no sample data that i can share because the file has been overwritten.