Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hola Comunidad, tengo un problema y quiero ver si me pueden ayudar.
Quisiera mostrar una tabla con la información de tickets creados vs tickets resueltos.
Ejemplo:
Día 26/08/2022 se crearon 23 tickets y se resolvieron 32 (18 del día 26/08/2022, y 14 de cualquier otra fecha anterior)
¿Cómo puedo esa mostrar eso en una tabla?
*Resultado esperado
Quiero seleccionar el cualquier día y que me diga cuando tickets se recibieron, cuantos pendientes y cuantos se resolvieron.
He tratado de hacerlo pero los filtros no me dejan ver los datos en la misma tabla, o veo los recibidos o veo los resueltos pero no ambos.
Si necesitan algo lo vemos.
Thank you!
Solved! Go to Solution.
Hi @Checonova ,
Please try below steps.
1. below is my test table
Table:
2. create a date table from "Table"
Table 2 =
CALENDAR (
FIRSTDATE ( 'Table'[Created Date ] ),
LASTDATE ( 'Table'[Resolution date] )
)
3. create three measure and add a table visual
Create Amount =
VAR cur_date =
SELECTEDVALUE ( 'Table 2'[Date] )
VAR tmp =
FILTER ( ALL ( 'Table' ), 'Table'[Created Date ] = cur_date )
VAR ctn =
COUNTROWS ( tmp )
RETURN
ctn
Pending Amount =
VAR cur_date =
SELECTEDVALUE ( 'Table 2'[Date] )
VAR tmp =
FILTER (
ALL ( 'Table' ),
'Table'[Created Date ] = cur_date
&& 'Table'[Status] = "In progress"
)
VAR ctn =
COUNTROWS ( tmp )
RETURN
ctn
Resolve Amount =
VAR cur_date =
SELECTEDVALUE ( 'Table 2'[Date] )
VAR tmp =
FILTER (
ALL ( 'Table' ),
'Table'[Status] = "Solve"
&& 'Table'[Resolution date] = cur_date
)
VAR ctn =
COUNTROWS ( tmp )
RETURN
ctn
Please refer the attached .pbix file.
Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Checonova ,
Please try below steps.
1. below is my test table
Table:
2. create a date table from "Table"
Table 2 =
CALENDAR (
FIRSTDATE ( 'Table'[Created Date ] ),
LASTDATE ( 'Table'[Resolution date] )
)
3. create three measure and add a table visual
Create Amount =
VAR cur_date =
SELECTEDVALUE ( 'Table 2'[Date] )
VAR tmp =
FILTER ( ALL ( 'Table' ), 'Table'[Created Date ] = cur_date )
VAR ctn =
COUNTROWS ( tmp )
RETURN
ctn
Pending Amount =
VAR cur_date =
SELECTEDVALUE ( 'Table 2'[Date] )
VAR tmp =
FILTER (
ALL ( 'Table' ),
'Table'[Created Date ] = cur_date
&& 'Table'[Status] = "In progress"
)
VAR ctn =
COUNTROWS ( tmp )
RETURN
ctn
Resolve Amount =
VAR cur_date =
SELECTEDVALUE ( 'Table 2'[Date] )
VAR tmp =
FILTER (
ALL ( 'Table' ),
'Table'[Status] = "Solve"
&& 'Table'[Resolution date] = cur_date
)
VAR ctn =
COUNTROWS ( tmp )
RETURN
ctn
Please refer the attached .pbix file.
Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Checonova , Very similar to HR blog, refer link or the file attached after signature
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |