I'm sure this must be very simple but I'm going round in circles trying to make this work.
I have a table of values broken down into quarters of a day e.g. 01/07/2014 06:00, 01/07/2014 12:00, 01/07/2014 18:00, 02/07/2014 00:00, etc and I'd like to build a simple line chart that shows the sum of the IN and OUT numbers but only show a single dimension label by day but have four data points between each day.
So currently I have this:
And I'd like something like this (ignore that it shows a label every four days as excel wouldn't let me break down a day into 4 segments)
I've also attached the sample app.
This is the best solution i could come up with. You DATE is text field which means you cannot use date functions on. You can change that to the date format using the following syntax in your script:
Date(MakeDate(Left(Right(DATE, Len(DATE)-6), Len(Right(DATE, Len(DATE)-6))-6),
Right(Left(DATE, Len(DATE)-11),len(Left(DATE, Len(DATE)-11))-3),
Hope this helps.
Thank you for your reply and attachment but the business wont accept a bar graph as the current BI tool is able to give them the data in a line chart.
Also I believe a much easier way to get the inline table to show the DATE field as a date data type would be to set the TimeStampFormat to being;
SET TimestampFormat='DD/MM/YYYY hh:mm[.fff]';
That seems to have worked to get the value translated.