Hi,
Are pivot charts okay to include in CP2? For some circumstances, a pivot chart, or table, can save a lot of time, in comparison to further data manipulation in order to get the correct format to produce the graph requested (for example April 2021 CP2, graphing 4 variables by month which requires additional steps to get the data in the right format).
I understand that pivot charts can cause issues, but if the data source and field values are appropriately documented in the audit trail, would we lose any marks for choosing a pivot over manually creating the chart?
Are pivot charts okay to include in CP2? For some circumstances, a pivot chart, or table, can save a lot of time, in comparison to further data manipulation in order to get the correct format to produce the graph requested (for example April 2021 CP2, graphing 4 variables by month which requires additional steps to get the data in the right format).
I understand that pivot charts can cause issues, but if the data source and field values are appropriately documented in the audit trail, would we lose any marks for choosing a pivot over manually creating the chart?