Forum Discussion
Need help creating new column based on Category
Hi Anonymous ,
Find attached the file. I added two rows to the mockup data with the same date to see whether that causes issues. It still worked.
Let me know, how it goes 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Hello tackytechtom Thank you so much for getting back. I'm stuck at step 4 where its giving me an error due to table can't determine the relationship between two or more fields.
I ensured both the datatype are same however the date column in my initial table obviously have same dates for different sites and its causing the relationship to me 'One to Many' Can you please help solving this issue or if you can share your example dashboard would be greatly appreciated.
Most Valuable ProfessionalHi Anonymous ,
The relationship one to many (date -> fact table) is correct. I need to recreate the report. I'll come back to you tonight.
/Tom
tackytechtom Sounds good. Thank you!!
- tackytechtom
Hi Anonymous ,
Find attached the file. I added two rows to the mockup data with the same date to see whether that causes issues. It still worked.
Let me know, how it goes 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/