Forum Discussion

Foolke's avatar
Foolke
Helper I
6 years ago
Solved

count with dates

I have data similar to this: TicketCreation_DateSolved_Date 1 4/05/2018 29/04/2020 2 8/05/2019 23/04/2020 3 17/07/2019 28/04/2020 4 28/04/2020 28/04/2020 5 20/04/2020 28/04...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hello @Foolke

    you can try to create a new table

    New Table = 
ADDCOLUMNS(
CALENDAR(TODAY()-14, TODAY()),
"Count",
CALCULATE(COUNTROWS('Table'),'Table'[Creation_Date]=EARLIER([Date])) - CALCULATE(COUNTROWS('Table'),'Table'[Solved_Date]=EARLIER([Date]))
)

    and use it for the visual bar

Foolke's avatar
Foolke
Helper I
6 years ago

Should look something like this:

X-axis: last 14 calendar days (start counting today)

Y-axis: (count of created tickets for date on X axis) minus (count of solved tickets on date on X-axis)

az38's avatar
az38
Community Champion
6 years ago

Hello @Foolke

you can try to create a new table

New Table = 
ADDCOLUMNS(
CALENDAR(TODAY()-14, TODAY()),
"Count",
CALCULATE(COUNTROWS('Table'),'Table'[Creation_Date]=EARLIER([Date])) - CALCULATE(COUNTROWS('Table'),'Table'[Solved_Date]=EARLIER([Date]))
)

and use it for the visual bar