Forum Discussion
Daily Delta Time Intelligence
Hi lapa44 -
Without see a sample of the data, I'm making a few assumptions. If the dates with blanks are in your data set then you can use a find and replace to change the null values to zero in the query window. If there are specific days where you need the data to be 0, then you can create a seperate date table and merge with your fact table and create a conditional column to set the specific dates to 0
In terms of the delta change.. You can download a sample file here..
https://drive.google.com/file/d/14GpDdpFTgDL5NV73vHU7P20mJxVCxHPD/view?usp=sharing
Hope this helps.
D
Hi lapa44 -
Without see a sample of the data, I'm making a few assumptions. If the dates with blanks are in your data set then you can use a find and replace to change the null values to zero in the query window. If there are specific days where you need the data to be 0, then you can create a seperate date table and merge with your fact table and create a conditional column to set the specific dates to 0
In terms of the delta change.. You can download a sample file here..
https://drive.google.com/file/d/14GpDdpFTgDL5NV73vHU7P20mJxVCxHPD/view?usp=sharing
Hope this helps.
D
How are you, brother davehus
I saw your solution to the problem and I liked it, but I had a problem with the my data, which is that each date is repeated three times because of the column of Status I hope you help me plz
Country Last_Update Incident_Rate Status Cases_Number Previous Last_Update
Spain 04/16/2020 395.570224334054 Recovered 04/15/2020 Spain 04/16/2020 395.570224334054 Active 184948 04/15/2020 Spain 04/16/2020 395.570224334054 Delta_Confirmed 7304 04/15/2020 Spain 04/16/2020 395.570224334054 Deaths 19315 04/15/2020 Spain 04/15/2020 379.948293204569 Recovered 04/14/2020 Spain 04/15/2020 379.948293204569 Active 177644 04/14/2020 Spain 04/15/2020 379.948293204569 Delta_Confirmed 5103 04/14/2020 Spain 04/15/2020 379.948293204569 Deaths 18708 04/14/2020
