Date functions with overlapping days causing distortions in Chart
Hi guys,
I have a problem which i'm not sure how to overcome. I have a requirement in which i want to display a
time/date value as the expression
Date as the x-axis
Initially I had trouble with formatting the data but I managed to use the subfield function which helped with this.
My time/date values span across days. You can see the problem I have within the sample app I have attached.
The problem is that when subfield is used (and I deem necessary as the chart won't work without it) and a timeoverlaps to a new day, it doesn't display correctly. I have attached text boxes in my app to explain my predicament better. I've tried a large number of options but don't see how I can get my chart to work. If anyone has any ideas, please feel free to comment. Thanks alot.
I am unclear what you want the data at 05/05/2010 to actually be. Are you trying to show the elapsed time from the start of the business day to the "Value" timestamp? So for 05/05/2010 you don't want 00:25:42 but actually 24:25:42? In that case, you'd want something like this:
interval(timestamp#(Value,'DD/MM/YYYY hh:mm:ss')-date#("Business Date",'DD/MM/YYYY'),'hh:mm:ss') as KPI_Time
