Forum Discussion
Stop Summarising Data in visualisation
Hi All, New user here - this is my first post on here... I'm really struggling to show price data in a visualisation. I have a range of products sold in a number of stores, each with a spec...
Hi Nickodemus,
We are able to use a Matrix visual to show the trend of each products' price varying over the weeks for each storeID, because we can add multiple row groups or column groups in a matrix, as is shown from below image.
However, if you want to convert this matrix to a line chart, ideally, there should display four lines to show the trend on one chart. It is not available to do that now, because we are not allowed to add both [StoreID] and [ProductID] into legend. So, I'm afraid, your requirement cannot be achieved now.
By the way, in a chart, values will be aggregated by default, but if we desgin the chart correctly, the aggregated result is the same as its actual value.
Best regards,
Yuliana Gu