Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

DATESMTD stops working

Hi everyone I have created a Dashboard which I have been using for a number of months now. One of the visuals is a cumulative line graph that reports month to date performance - it updates daily. T...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

Based on the details you’ve provided, it appears that the DATESMTD function is not returning any data for the new table ‘MstrQRObs’. To gain a more comprehensive understanding of the issue and to facilitate further troubleshooting, could you kindly provide the following information?

  • Please check if there is any data in the table 'MstrQRObs' during the selected period?
  • Please make sure that the relationship between MyCalendar2 and MstrQRObs is set up correctly. The Date field in MstrQRObs should be linked to the Date field in MyCalendar2.

  • Please check if the table 'MstrQRObs' has the same settings with the table 'SamoaQR_Obs'? Data type, data, relationship etc.

Best Regards