Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Olá amigos,
Estou com dificuldades em criar um gráfico de chrun de clientes. A ideia era ficar algo desse tipo:
Unica diferença que gostária de unidade no eixo Y.
Os dados que tenho em tabela são. Email, telefone, Status (Ativo ou Cancelado), Data de Inicio e Data de Fim (se estiver ativo é sempre o dia atual).
Outro detalhe, gostária que fosse no tipo por "safra", Uma das linhas é os clientes que entraram no Mês 1, a outra Mês 2 e assim por diante.
Estou perdido. Por favor, me deem uma luz.
Grato desde já!
Solved! Go to Solution.
Hi @Marlon
It seems you may create a table like below and then create different measures to get the different lines.
Table = FILTER ( GENERATE ( 'Date', Table1 ), Table1[Join Date] <= 'Date'[Date] && Table1[Left Date] >= 'Date'[Date] && Table1[Status] = "Active" )
Regards,
Hi @Marlon
It seems you may create measures to get different line values.For example:
MeasureForMonth 1 = CALCULATE ( COUNT ( Table[Customer] ), FILTER ( Table, Table[Month] = 1 ) )
If it is not your case,sample data and expected output will be helpful to provide an accurate solution.Please refer to How to Get Your Question Answered Quickly to post your question.
Regards,
Hello @v-cherch-msft , thanks for awnsering.
The data is like this
Nome | Phone | Join Date | Status | Left Date | |
Person1 | person1@email.com | 11111111111 | 03/01/2019 | Active | 27/03/2019 |
Person2 | person2@email.com | 2222222222 | 08/01/2019 | Canceled | 07/03/2019 |
Person3 | person3@email.com | 3333333333 | 13/01/2019 | Active | 27/03/2019 |
Person4 | person4@email.com | 4444444444 | 07/02/2019 | Active | 27/03/2019 |
Person5 | person5@email.com | 5555555555 | 09/02/2019 | Canceled | 09/03/2019 |
Person6 | person6@email.com | 6666666666 | 13/03/2019 | Active | 27/03/2019 |
Person7 | person7@email.com | 7777777777 | 06/03/2019 | Active | 27/03/2019 |
And i want to show a graphical like in the first post.
Being the Y = Count of how many person are active and X = Month. But i want to separe the datas like one line for who joined in january, a line for who joined Febuary...
Thanks for your patience and sorry for my english.
Hi @Marlon
It seems you may create a table like below and then create different measures to get the different lines.
Table = FILTER ( GENERATE ( 'Date', Table1 ), Table1[Join Date] <= 'Date'[Date] && Table1[Left Date] >= 'Date'[Date] && Table1[Status] = "Active" )
Regards,
User | Count |
---|---|
131 | |
108 | |
101 | |
67 | |
64 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |