evidence icon indicating copy to clipboard operation
evidence copied to clipboard

[Docs]: Show example of how to aggregate percentage changes in DataTable

Open archiewood opened this issue 1 year ago • 1 comments

Request Type

Explanation Improvement (make a description clearer for the reader of the docs)

Description

Need to use custom weight column.

https://evidencedev.slack.com/archives/C0239KTKHH7/p1727458101810239

archiewood avatar Sep 29 '24 08:09 archiewood

I asked the original question on Slack. Percent change aggregations need totalAgg=weightedMean and weightCol set to the "old value" (for example, if comparing sales to sales_year_ago, weightCol should be sales_year_ago). The current docs always use the "new value" (sales) when a percent change subtotal example is provided.

nickfanion avatar Oct 01 '24 14:10 nickfanion