Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Marlon
Frequent Visitor

Ajuda Com Grafico de churn!

Olá amigos,

 

Estou com dificuldades em criar um gráfico de chrun de clientes. A ideia era ficar algo desse tipo:

img_56475aa1a2bd1

 

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á!

 

 

1 ACCEPTED 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,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-cherch-msft
Employee
Employee

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,

 

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hello @v-cherch-msft , thanks for awnsering.

 

The data is like this

NomeEmailPhoneJoin DateStatus
Left Date
Person1person1@email.com1111111111103/01/2019Active27/03/2019
Person2person2@email.com222222222208/01/2019Canceled07/03/2019
Person3person3@email.com333333333313/01/2019Active27/03/2019
Person4person4@email.com444444444407/02/2019Active27/03/2019
Person5person5@email.com555555555509/02/2019Canceled09/03/2019
Person6person6@email.com666666666613/03/2019Active27/03/2019
Person7person7@email.com777777777706/03/2019Active27/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,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.