Forum Discussion

drnareshchauhan's avatar
drnareshchauhan
Icon for Helper I rankHelper I
6 years ago

DOUBLING TIME FOR COVID-19 CASES

[ Spoiler ] amitchandak  HI CAN ANYONE SUGGEST HOW TO PLOT DOUBLING TIME IN COVID-19 DATA  MY DATA FOR CONFIRMED , DISCHARGED AND ACTIVE CASE IS IN SINGLE COLLUMN AS TEXT FIELD THAN
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
6 years ago

drnareshchauhan 

For me, it is not clear of your expected solution regarding to that "Double confirm" or "Double death". Basically I am confused with the ThresholdValue and Day of Half variables. Can you explain that measure?

Days to Double = 
VAR CurrentDay = MAX(COVID[Date])
VAR ThresholdValue = 
    CALCULATE(SUM(COVID[Value]), COVID[Date] = CurrentDay) / 2
VAR DayOfHalf =
    CALCULATE(
        MAX( COVID[Date] ),
        FILTER(
            ADDCOLUMNS(
                SUMMARIZE( ALL(COVID), 'Calendar'[Date]),
                "Amount", CALCULATE( SUM( COVID[Value] ) )
                ),
                [Amount] < ThresholdValue
        )
    )
VAR DoublingTime = (CurrentDay - DayOfHalf) * 1
VAR Result = IF(AND( DoublingTime < 10000, DoublingTime > 0), DoublingTime)
RETURN
Result

 

Regards
Paul

drnareshchauhan's avatar
drnareshchauhan
Icon for Helper I rankHelper I
6 years ago

Anonymous 

thanks 

I have this report file of county, thanks to you but this doesn't work for me

becase the value in the given file of yours is the cumulative value, where in my data similar column is [new confirmed] which is daily occurence of cases date wise , i did running total to get the cumulative (threshold value) but your above solution willl not take that calculated measure [ ].

and when I tried to add running column it turned out some weird values in millions 

thanks