Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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?

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    I redo the query and it works again.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    I redo the query and it works again.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Anonymous

     

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Anonymous, 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.