Forum Discussion
dynamic matrix for store opening date
Hello everyone, I ask you why I can not solve a problem of visualization
I have to create a table filtered by date on store sales, the result must be like this:
Negozio | Val gen 2018 | Val gen 2017 |
TORINO | 100 | 89 |
MILANO | 200 | 165 |
FIRENZE | 125 | 100 |
ROMA | 75 | 45 |
PALERMO | 500 | 455 |
NAPOLI | 433 | 400 |
VENEZIA | 245 | 200 |
Totale | 1.678 | 1.454 |
ASTI | 300 | 0 |
CAGLIARI | 154 | 0 |
Totale | 2.132 | 1.454 |
my problem is that I can not make sure that depending on the opening date of the store the matrix divides the stores into two subtotals, the first containing the stores that were open in 2017 and the second those that were opened after the first date of analysis.
statically I can recreate it but not if I use date selectors for analysis, for example in the same dashboard perform the analysis February 2018 and January 2018.
the table should change depending on whether the year before was open or not
3 Replies
- Greg_DecklerCommunity Champion
What does the original, raw data look like?
- Marcox28Helper II
the original data is on a table containing each line a receipt with three main columns:
data negozio valore scontrino 01/01/2017 TORINO 20,4 02/01/2017 MILANO 30 03/01/2017 TORINO 34 04/01/2017 PALERMO 50 05/01/2017 VENEZIA 15 03/02/2018 MILANO 100 04/02/2018 MILANO 3 05/02/2018 PALERMO 21 06/02/2018 PALERMO 34 07/02/2018 VENEZIA 15 - Marcox28Helper II
I also have a table stores containing the opening date of the store.negozio data apertura MILANO 14/07/2016 TORINO 04/06/2015 PALERMO 15/07/2013 VENEZIA 15/12/2014 ASTI 03/05/2017 CAGLIARI 06/11/2017