Hi Community,
Whenever I select more than one time period in the time filter (e.g. March and April 2011), each associated graph / diagram goes totally blank!
This problem is not caused by different time / date formats, I'm using the same date format through the entire database table. Technically it should work, but it does not, and I don't know why.
Is there anything I could do? Any help is (again) appreciated :D
Its hard to help you based on the information you provided. But it might be useful to copy the SQL statement you are dynamically composing and sending to the database. You could do so by
- utilizing the copy single value operator and
- inserting the SQL statement into a new column of type text which is
- feeding a textfield displayed inside your MashApp
That way you can ensure that the date picker and date conversion works as expected.