Graph to show growth rate

[srinutamada]

Hi All,

I am having the data of a SP site usage for last 6 months. I have the data for each day (table is having separate column for complete date, month, day and year) in a tabular format. Now I have to draw a chart for usage growth rate for each month. So could you please suggest is there any way to implement this.

And also all charts on my dash board are interactive and shows data based on filters, so the new graph also should reflect growth rate based on those filters.

You suggestion are more welcome.

Regards,

Srinu Tamada

[v-chuncz-msft]

@srinutamada,

Based on my test, you could refer to the following steps.

1) add a new table

Table2 = 
GROUPBY (
    Table1,
    Table1[year],
    Table1[month],
    "usage", SUMX ( CURRENTGROUP (), Table1[usage] )
)

2) add a calculated column

growth rate = 
VAR Prev =
    LOOKUPVALUE (
        Table2[usage],
        Table2[Table1_year], Table2[Table1_year],
        Table2[Table1_month], Table2[Table1_month] - 1
    )
RETURN
    (
        IF ( ISBLANK ( Prev ), 0, ( Table2[usage] - Prev ) / Prev )
    )

3) format column "growth rate" as percentage