Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Chart with number boolean

Hi,   My dataset is a calendar of this kind :   For each date i have the year and boolean opendays I would like to create a graph which count the number of open days by year like Excel : ...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi Anonymous 

     

    Please share a sample of your data in a format that can be copied (paste it into the post from excel, not a screen shot) and include samples from each table involved.

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I have problem to import my array :

date            year   Open
01/01/2018 2018 FALSE
02/01/2018 2018 TRUE
03/01/2018 2018 TRUE
04/01/2018 2018 TRUE
05/01/2018 2018 TRUE
06/01/2018 2018 TRUE
07/01/2018 2018 FALSE
08/01/2018 2018 TRUE
09/01/2018 2018 TRUE
10/01/2018 2018 TRUE
31/12/2018 2018 TRUE
01/01/2019 2019 FALSE
02/01/2019 2019 TRUE
03/01/2019 2019 TRUE
04/01/2019 2019 TRUE
05/01/2019 2019 TRUE
06/01/2019 2019 TRUE