Forum Discussion
Comparing dates from two different tables
I have 2 tables, the first contains all the transactions(TransactionTable) and the second one contains all the dates (DateTable) from 1st Jan 2018 to 31st Dec 2021. I have a expired date for each...
Anonymous
I don't understand what you mean?
You need to have a way to relate/link the Date and the transaction table. If you want to plot the number of expired products against date, you just need to create a relationship between expiry date and the date in your date table.
Then put Month or date[date] and transaction[item] in the visual with summarization of item set to COUNT.
I don't understand what you mean?
You need to have a way to relate/link the Date and the transaction table. If you want to plot the number of expired products against date, you just need to create a relationship between expiry date and the date in your date table.
Then put Month or date[date] and transaction[item] in the visual with summarization of item set to COUNT.