This content has been marked as final. Show 13 replies
I'm getting crazy because - I guess - a small problem:
I import Data from a SQL-Database with OLE-DB - there is a data field (Date) with the format DD.MM.YYYY hh:mm.
My settings look like that:
SET TimestampFormat='DD.MM.YYYY hh:mm';
In another field a got some Entries per Month (SU_TIME) over 3 years.
Now I just want to show the average per month with AVG() and select one year as following:
Dimenson is just Date.
The diagramm won't show any data to me.
Even simple if-statements do not work with Date ...
Hopefully you can help me!
Thanks a lot,