I tried that, and I still have the same problem.
Remember that I want to show the current month in the USA.
So if today is Dec 31st at 10 AM here in the USA now in Japan, it is Jan 1st, if I use a calculated fields that are based on this month the field will be blank.
Same would happen if I use a relative date filter and select this month. Tableau is looking at as January and not December.
Ah, I see.
Maybe there is something on the server side that can be done? Let's see if any other guys are on today.
I will say that this is a slow time for the forums because a lot of people are on vacation. So if this doesn't get solved this week, there's still hope for next week
But again I'll state that this is a very interesting case and I think this would be interesting to see the solution.
Without too much detail, why is the server in Japan? Are you working with global-type data?
Japan is where the corporate headquarter is located. Thanks for your replies.
I was hoping to fix a few vizs before the month & quarter end. Thanks again.