Data in table and visualizations not matching

[Anonymous]

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

[kschaefers · Accepted solution]

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]

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