Forum Discussion

Marcox28's avatar
Marcox28
Helper II
8 years ago

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

    • Marcox28's avatar
      Marcox28
      Helper II

      the original data is on a table containing each line a receipt with three main columns:

       

      datanegoziovalore scontrino
      01/01/2017TORINO20,4
      02/01/2017MILANO30
      03/01/2017TORINO34
      04/01/2017PALERMO50
      05/01/2017VENEZIA15
      03/02/2018MILANO100
      04/02/2018MILANO3
      05/02/2018PALERMO21
      06/02/2018PALERMO34
      07/02/2018VENEZIA15
      • Marcox28's avatar
        Marcox28
        Helper II
        I also have a table stores containing the opening date of the store.

         

        negoziodata apertura
        MILANO14/07/2016
        TORINO04/06/2015
        PALERMO15/07/2013
        VENEZIA15/12/2014
        ASTI03/05/2017
        CAGLIARI06/11/2017