I'd be extremely grateful if someone is able to guide me through a solution to this. This would then result in the correct graph showing horizontal lines for all the weeks where the price is unchanged, and then the rise/fall when the price changes. I'm totally at a loss as to how to get this thing to work so that i populates the correct price for each week (effectively filling the gaps), but changes appropriately if there is a price change. I also have a Date table which is NOT connected to the price table (as instructed in your other post). The line chart and matrix below it are the result of the following measure for "Last Price": My prices show as horizontal lines on the line chart, for each product only reading as the maximum price. I can't seem to get this to work as you describe in the other post you linked to. Hi for the huuge delay getting back to you. what would be the expression for this measure. Are you able to suggest the best way to plot this? I.e. if the price changed on Monday to £10, then on Friday the 'current' price is still £10. It feels like i need a measure(?) which calculates the 'Current' price for any given date, represented by the last price recorded for that product and variant prior to the date being plotted.Į.g. I guess i'm saying the 'current' price is the 'last price' recorded. I think this is where the initial suggestion could come in. there's no data for the date) the line will be horizontal. What i want to show is effectively a chart of the 'current' price on every day. What's missing there is that you can see in the chart that the 'A-Large' line stops short of the end, because it's where the data stops. Combining the two fields into a single calculated column makes a lot of sense. To be honest, I think it's a combination of the two that i need. Thanks and both really useful suggestions.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |