RanjitR

Discussions

Charting rolling n weeks based on week number selected in the dashboard filter
Hello, I have a weekly dataset with 'week number' as dashboard filter. I would like to create a chart showing rolling 8 weeks trend leading up to the week selected in the filter. For instance, if the user selects week 18, the chart should display weekly trend from Week 10 to week 18. How can I achieve this? Thank you!
Calculating Summary Level Average of a Calculated Field
Hello, As you see below, the table breaks down weekly average transaction by week for the current period and year, how do I get the average of both weeks at the summary level? WPSA-Transaction is a calculated field that uses this formula to calculate average per week (SUM(`CY_TRANSACTION`) / COUNT(DISTINCT `STORE_ID`))…

Charting rolling n weeks based on week number selected in the dashboard filter
Hello, I have a weekly dataset with 'week number' as dashboard filter. I would like to create a chart showing rolling 8 weeks trend leading up to the week selected in the filter. For instance, if the user selects week 18, the chart should display weekly trend from Week 10 to week 18. How can I achieve this? Thank you!
Calculating Summary Level Average of a Calculated Field
Hello, As you see below, the table breaks down weekly average transaction by week for the current period and year, how do I get the average of both weeks at the summary level? WPSA-Transaction is a calculated field that uses this formula to calculate average per week (SUM(`CY_TRANSACTION`) / COUNT(DISTINCT `STORE_ID`))…