I am using CR10 with a spreadsheet for the data.
My issue is that I am trying to create a dual Y axis chart showing a time field on the left and a % field on the right.
I cannot get the time side to work correctly with the chart.
The field is pulling in as a date/time and when I add it to the values to show on the chart it will only show count and distinct count as the aggragation choices. I do not need to aggragate because my data is already calculated but it grays out the 'Do not summarize' button.
Is there a way to get the time to show correctly? I've tried converting it but it doesn't seem to work.
I've also stripped off the time in the field but it still forces me to either count or distinct count the field in the chart.
The customer has the chart in excel right now but wants it automated.
Any help would be greatly appreciated!!
My issue is that I am trying to create a dual Y axis chart showing a time field on the left and a % field on the right.
I cannot get the time side to work correctly with the chart.
The field is pulling in as a date/time and when I add it to the values to show on the chart it will only show count and distinct count as the aggragation choices. I do not need to aggragate because my data is already calculated but it grays out the 'Do not summarize' button.
Is there a way to get the time to show correctly? I've tried converting it but it doesn't seem to work.
I've also stripped off the time in the field but it still forces me to either count or distinct count the field in the chart.
The customer has the chart in excel right now but wants it automated.
Any help would be greatly appreciated!!