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 ...
i have looked at you solution but lookingfat you data structure, it does not match the structure in my sql server as this is like this
| date_lw | sales_lw | date_2w | sales_2w | change in sales | numebr of satff that made sales | number of people that made purchases |
| 01/01/2022 | 1000 | 08/01/2022 | 2500 | 1500 | 10 | 50 |
so even if i could use you method the extra columns "change in sales, numebr of satff that made sales and number of people that made purchases" would end up being duplicated for each date which would look like this
| 01/01/2022 | 08/01/2022 | ||||||
| sales | change in sales | numebr of satff that made sales | number of people that made purchases | sales | change in sales | numebr of satff that made sales | number of people that made purchases |
| 1000 | 1500 | 10 | 50 | 2500 | 1500 | 10 | 50 |
but what i need is like this
| 01/01/2022 | 08/01/2022 | change in sales | numebr of satff that made sales | number of people that made purchases |
| 1000 | 2500 | 1500 | 10 | 50 |