Forum Discussion
Dynamic Column according to date selected
Hello guys,
I'm trying to calculate the amount of orders grouping by status in the selected date. I have a fact Sales, Calendar and a fact Historical Sales
fSales
| id_order | sales date |
| ab123 | 01/01/19 |
| ab124 | 02/01/19 |
| ab125 | 02/01/19 |
| ab126 | 03/01/19 |
fHistoricalSales
| id_Order | DT_Status | Status |
| ab123 | 01/01/19 | NOR |
| ab123 | 15/01/19 | CAN |
| ab124 | 02/01/19 | NOR |
| ab124 | 13/01/19 | CAN |
| ab125 | 03/01/19 | NOR |
| ab125 | 14/01/19 | CAN |
| ab125 | 20/01/19 | REC |
| ab126 | 05/01/19 | NOR |
I can count the Id orders if I get the last status order like following image.
But I'd like when I select the range date like from 01/01/2019 to 13/01/2019 I get the status the orders were in that time, not the last status, like this:
Thanks!
1 Reply
Anonymous ,
Why the count value of 01/JAN with NOR is 1? Isn't it 2? Could you share more logic of the matrix chart?
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
