Create multiple row using two dates difference?

Question & Answer
1

I have 3 columns, unique serial number, start date, end date
If start date is 3/1/2022 and end date is 3/15/2022.
I want to create row for each day till 3/15/2022 to count no of incident

2

You can do this by adding calculation field.

addDateTime(amount , period , datetime )

3

Do you want see data for dates between 03/01 - 03/15 in a line chart? If yes, then there is a “Show date gaps” option under X-Axis settings in the Format Visual pane.

If you are displaying data using a different chart (e.g. table), you will need to change dataset to join the data with another table that has all possible dates.

1 Like