Multiple Dates on child table joined to Audit.Date
I have a table with multiple dates that have been joined to the Audit.Date table to take advantage of the meta data from the date dimension (month name for example.) The problem is when I use an insight to group by the month name, I cannot find a way to control which date field from the child table to use.
The table has CreateDate, UpdatedDate, and PaymentDate all joined to Audit.Date.date. Using a column chart, I use Month Name as the grouping dimension. What I observe is that the CreateDate is being used as the underlying pull for rows. I need to use the UpdateDate.
I am also wanting to summarize by the month and not the individual dates.
How can I accomplish this?
Marc, you have created a relationship between which column of your child table with the audit.table.
also the sequence of joins. As per my observation, I think since the join is first on CreateDate and then on other dates, Incorta is using the first join by default for populating the data.
Regarding summarizing by month, can you please elaborate.