Forum Discussion
linking both facts based on date condition
Hi Experts, i have two facts and a date table, all three are date with timestamp. Datetable(timestamp) M:1 Custfacts (timestamp) - relationship is active Datetable(timestamp) M:1 Salesfacts...
While you can do that with row context is taken care. What is the output you want using that
amitchandak
Super User
Super UserWhile you can do that with row context is taken care. What is the output you want using that
Sir,
My line chart is no of customer id and bar chart is sales value based on hour
from date table/ hour column = 10 ,12 ,14, 16
line chart is no of customer id= 19,22,38,33
bar chart 0.5k, 0.4k,0.3k
As mentioned by you created timestamp table and joined with 2 facts table and formula is working