Forum Discussion

srinutamada's avatar
srinutamada
New Member
9 years ago

Graph to show growth rate

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

1 Reply

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    9 years ago

    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