Hello @ll! I need your expert help, please!
I have a table with service field orders, that can have several different states (from open, programmed, review, analysis, closed, etc), and i need to show on a dashboard, how many orders i had in a previous date (date slicer) .
For example, for this data sample:
| ID Order | State order code | Date Order State | Order |
| 7232724 | OG | 03/11/2007 | 6 |
| 7232724 | OP | 03/11/2007 | 5 |
| 7232724 | OE | 08/05/2008 | 4 |
| 7232724 | OC | 19/12/2008 | 3 |
| 7232724 | OA | 19/06/2009 | 2 |
| 7232724 | OA | 19/06/2009 | 1 |
i need to the expected result to be:
| Date slicer start | Date slicer end | Expected order result |
| 01/01/1900 | 02/11/2007 | |
| 02/11/2007 | 03/11/2007 | 5 |
| 04/11/2007 | 07/05/2008 | 5 |
| 08/05/2008 | 18/12/2008 | 4 |
| 19/12/2008 | 18/06/2009 | 3 |
| 19/06/2009 | 19/06/2009 | 1 |
| 19/06/2009 | 31/12/2099 | 1 |
i need to show for each state order code, wich was the amount of differente orders on that state on a given date/period.
Can you help? Thank you @all!
