Forum Discussion
Two categorical variables, one date variable - not lining up
Hi all - I am creating a table with two categorical variables (Result and Target) and one date variable (Measured Date). All the variables come from one data connection. I changed the data type of the Measured Date variable from date/time to date. There are a few rows of Results and Targets that have the same date, yet they don't merge to one row of data with that date, the date is duplicated. The attached image will do a better job at explaining. I would like one row of data per date.
Thank you!
1 Reply
Anonymous it can be surely achieved but simpler might be having two tables , one for target and result. and once you have two tables, you can set relationship on date between them and visualize the data from both the tables.
