Good evening!
We have a data set from some productionhouse. From their point of view the start of their work is around 22:00 o'clock and they end around 17:00 o'clock. So they are starting for example at 22:00 16.01.2017 and had their end of work at 17:00 17.01.2017. Each product that is manufactured inbetween gets a timestamp (hh:mm) and a datestamp. They are both in different columns. The twist lies in the datestamp, because even if they are starting on 16.01.2017 at 22:00 the datestamp for this data set will automatically make the 17.01.2017 22:00.
To describe it better I try to show it in two tables.
In the first table i show you the actually time and date the normaly would be shown in a Table.
| Product | Time | Date |
|---|
| A | 22:00 | 16.01.2017 |
| B | 23:00 | 16.01.2017 |
| C | 0:00 | 17.01.2017 |
| D | 4:00 | 17.01.2017 |
And now how the data is when I look at the table
Product
| Time | Date |
|---|
| C | 0:00 | 17.01.2017 |
| D | 4:00 | 17.01.2017 |
| A | 22:00 | 17.01.2017 |
| B | 23:00 | 17.01.2017 |
To show ho many products are created in an hour I created a bar chart with the Dimension '=hour(time)' on the Y-Achse and a formula that just counting the Products. So far it is ok and the values are right. The Problem comes with the follow requirement. When we show the bar chart, the bars are orderer like in table 2. On the first place 0.00 hr and how many products has been manufactured in this hour. The last bar is the 23hr bar. The customer wants have a change in the rankings or in the sort of this bar, that the hour will on the y-achse will be wortet like in table 1 of my example.
I tried already in the sort expression the match() funktion and also researched a little bit about the dual() funktion, but couldn't find a clue about a solution. Could someone please guide me in the right direction. If it doesn't work with the sort expression, could the solution lie within the backend...maybe in creating a new column, that will change the date befor 00:00 in the right date. But sadly I don't have to much experience at the backend.
I would appriciate any Help that I could get.
Many thanks in advance.
