Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey All.
I am creating a Bar Chart based on hours in a day.
I have the data hourly, but the problem is that our business day's start at 4 am (no this cannot be changed)
And the chart will automatically sort from 01:00:00 to 02:00:00 and so on.
We would like to see the chart start at 04:00:00 move from there.
How can i achieve this offset?
If i go to the sort tab in the properties i cannot seem to fix this.
You can either use Wildmatch in the sort by Expression options:
WildMatch(Time,04:00:00,05:00:00...)
or use Dual in the load sscript
Data:
mapping load * Inline
[ Time,Value
04:00:00,1
05:00:00,2 ]...
ans so on...
Sort:
load
Employe,
dual(Time,ApplyMap('Data',Time)) as Rate
FROM
You can either use Wildmatch in the sort by Expression options:
WildMatch(Time,04:00:00,05:00:00...)
or use Dual in the load sscript
Data:
mapping load * Inline
[ Time,Value
04:00:00,1
05:00:00,2 ]...
ans so on...
Sort:
load
Employe,
dual(Time,ApplyMap('Data',Time)) as Rate
FROM
Try sorting by an expression. Something like mod(only({1}Time)*24-4,24). See attached example.
Hi mike
Please try with mod(only({1}Time)*24-4,24) it should work.
thanks
Unfortunately mod(only({1}Time)*24-4,24) wont work, it errors on 'Time' (red underline)
Wildmatch wont work either.
I guess i can try the script.
Was hoping that wasn't needed.
Replace Time with the name of the dimension that contains your hour values.
Lol, i should have known that.
however, the sorting gets messed up if i do this, see picture.
Could you post your file?
Are you sorting by both of your expression?
Unfortunately i cannot considering it is based on a different server without direct access.
i will try everyone's suggestions again after my reload.
Thanks in advance!