Preserving the required metrics/dimensions in a certain order while creating reports using Report Builder, and saving the templates by naming it properly is the key to build automated dashboards. Keep the raw the data in one sheet (don't forget to set the preserved order), and the formatted one in other (just apply the formula once - connect the data with charts).
Every time you refresh the report with a different date range or different RSIDs due to preserved order set in the raw data sheet, the formulas applied in the formatted sheet connecting the raw data works superbly.
Truly amazing! Thanks for sharing..social media marketing agency
ReplyDeleteWonderful blog. This is very useful post. Thanks for sharing.
ReplyDeleteSEO Services in Chennai