Forum Discussion
It is so simple - just dates on a line graph...
All,
Too many hours wasted trying to get this to work... I have a report that has a Direct Query link to a Dynamics CRM table. The table contains fields that record when cases were created (Case). It uses the default Created On field which is a Date and Time field (Time zone adjustment User local if that is relevant). I want a chart that has dates along the bottom and Count of the Cases field to show how many cases were created each date. Simple...
But the chart only ever shows 1 record per date (with the odd exception) as its taking each time stamp as a unqiue value - see below. I just want it to group it by dates and ignore the time. I have attempted to play with formats but can't get it working. This is an out the box Microsoft Date and Time field so I know the data is good. Help please...!
11 Replies
Add a calculated column that gets the DATEVALUE() of your timestamp, and use that in the X axis instead.
For some reason its saying that the column is not suitable for this - but its a standard date time automatic field from Dynamics?
You need to create a calculated column, not a measure.
Thanks - can I do that if its a Direct Query link to the data?
yes, you can have calculated columns in Direct Query as long as they originate from the same row.
