Forum Discussion
visuals stop working with dynamic column names
hi all , i have a dashboard that uses weekly sales data from a sql server the table i have looks somthing like this. date_lw sales_lw date_2w sales_2w date_3w sales_3w date_4w sales_4w ...
unfortunalty this method does not work for due to the data in my sql server not being structured like this and that the desired table does have more columns that only partain to the sales_lw so using the matrix column method would mean these extra columns being duplicated