This helps protect our community. Learn more

Displaying the distribution of distance between transactions - Unplugged #19

120K subscribers

5.9K views 4 years ago #unplugged

How to display the distribution of the distance between transactions in a column chart? Let's see how to implement a complex calculation splitting a complex problem into smaller simple steps. Download sample file: https://www.sqlbi.com/tv/displaying-t... Read more about the "unplugged" format: https://www.sqlbi.com/blog/marco/2021... #unplugged

...more

These chapters are auto-generated

Displaying the distribution of distance between transactions - Unplugged #19

244Likes

5,991Views

2021May 15

Transcript

Follow along using the transcript.

SQLBI

120K subscribers

Displaying the distribution of distance between transactions - Unplugged #19

Chapters View all

Introduction

Introduction

Introduction

Problem definition

Problem definition

Problem definition

Creating the table

Creating the table

Creating the table

Running the code

Running the code

Running the code

Converting the previous date into a variable

Converting the previous date into a variable

Converting the previous date into a variable

If statement

If statement

If statement

Group by

Group by

Group by

Current Group

Current Group

Current Group

SQLBI

Displaying the distribution of distance between transactions - Unplugged #19

Comments 25

Chapters

Introduction

Introduction

Introduction

Problem definition

Problem definition

Problem definition

Creating the table

Creating the table

Creating the table

Running the code

Running the code

Running the code

Converting the previous date into a variable

Converting the previous date into a variable

Converting the previous date into a variable

If statement

If statement

If statement

Group by

Group by

Group by

Current Group

Current Group

Current Group

Simple Approach

Simple Approach

Simple Approach

Filtering

Filtering

Filtering

Relationship

Relationship

Relationship

Measure

Measure

Measure

Conclusion

Conclusion

Conclusion

Description

Chapters View all

SQLBI

Transcript

Consecutive days with no sales - Unplugged #18

Chapters

Chapters