Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

multiple date tables to only use 1 date. How?

I have 6 data sets, all with graphs. I need them all to use 1 date, but each time i make the date table it doesnt work.    I have tried user relationship which retrns an incorrect syntax error mess...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi,

 

these are 2 data sets. Notices report and Late notices. I want to replace the issue date with a calendaer table date and count the local ref.

 

 

 

I changed the directin to both and now blanks. I need the top left date to be calender date to run both visuals.

 

Thanks

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous 

Do you want to calculate the sum of the number of local refs that match the selected date in the two tables based on the date selected in the date table?

 

Best Regards!

Yolo Zhu

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous 

     

    I want to count them. I want to put both data sets on 1 line chart eventually using the 1 date from the calender, as well as individual graphs using 1 slicer.

     

    Thanks