Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Data in table and visualizations not matching

Hi,

 

Please take a look at the attached picture. The table shows the data which is basis for the visualizations. Note that the filter on “Company Name” is not working properly and several sessoinIDs appear more than once, which is wrong according to the table of data and the fact that the sessionID is a unique identifier. The visualizations are also showing wrong dates for the sessionids.

 

The data in the visualizations are all gathered from the same table, so this is not a relationship issue. Please provide some insight on what can be wrong

  • It looks like your session id is included in the visual as a calculation, when it should be a dimension. Make sure there is no calculation applied, such as COUNT, SUM. Alternatively classify the SessionID column as data type text. 

     

    Currently it probably shows the number of sessions for the days selected, rather than the actual session id. 

2 Replies

  • It looks like your session id is included in the visual as a calculation, when it should be a dimension. Make sure there is no calculation applied, such as COUNT, SUM. Alternatively classify the SessionID column as data type text. 

     

    Currently it probably shows the number of sessions for the days selected, rather than the actual session id. 

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks, I'm fairly new to this still. The default was COUNT and it didn't occur to me to check :)