topic Re: Graph to show growth rate in Developer

Graph to show growth rate

srinutamada — Tue, 13 Sep 2016 18:20:06 GMT

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

Re: Graph to show growth rate

v-chuncz-msft — Thu, 15 Sep 2016 11:09:34 GMT

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