cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
wyin Regular Visitor
Regular Visitor

Data did not aggregate

Hi,

 

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?

1 ACCEPTED SOLUTION

Accepted Solutions
wyin Regular Visitor
Regular Visitor

Re: Data did not aggregate

I redo the query and it works again.

3 REPLIES 3
wyin Regular Visitor
Regular Visitor

Re: Data did not aggregate

I redo the query and it works again.

Highlighted
Super User
Super User

Re: Data did not aggregate

Hi @wyin

 

Logically your measure should aggregate with the dimension . Can you share some sample data and the formula you are using in the measure?

 

Thanks

Raj

wyin Regular Visitor
Regular Visitor

Re: Data did not aggregate

@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.