Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hello folks,
I would like to display on a "line and clustered chart" the number of tickets opened and closed per year week.
First I have my data table that looks like this :
To do that, I followed the answer given in this topic LINK
I created a calendar table and I linked it to the "creation date" :
To finish, I created two columns in the table to put a 0 or 1 if closed or opened :
Hi @Anonymous ,
this happens because you connect to [Created date]. You need to add a new relationship between your two tables, between Calendar[Date] and Data[Closed date]. This second relationship will be inactive. In order to make use of it, you have to use the USERELATIONSHIP-function inside a measure, something like this
measureClosed = CALCULATE ( SUM ( Data[Closed] ); USERELATIONSHIP ( Data[Date Closure]; Calendar[Date] ) )
As for your cumulative count, it will depend a little on you Calendar-table, but in general it should look something like this
cumulative open = CALCULATE ( SUM ( data[open] ); FILTER ( ALL ( Calendar ); Calendar[Week] <= MIN ( Calendar[Week] ) && Calendar[Year] = MIN ( Calendar[Year] ) ) )
Cheers,
Sturla
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
24 | |
19 | |
14 | |
10 | |
7 |