Hello All,
I'm trying to create a Straight table that shows Sales Orders placed every day. These are the field objects I'm including, but I'm having trouble figuring out which should be dimensions and which should be expressions. I'm also having trouble figuring out what expressions to use. I'm also unsure if I should be using Transaction Dates or Canonical Dates. Would you be able to help?
1. Transactions.Sales Order Number
2. Customer.Full Name
3. Transactions.Item Full Name
4. CanonicalCalendar.Day
5. CanonicalCalendar.Month
6. CanonicalCalendar.Year
Thanks,