Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello,
I have a problem because I would like to see the prices of 6 months as you can see in the screenshot I have only one price from this year missing 5 from the previous year
this is the script I use to display prices
Max({<gueltig_ab={">$(=AddMonths(Max(gueltig_ab),-6))"}>}Preis)
Could it be that you don't want to show the last 6 month else the last 6 price-entries? In this case you may try to use max(Date, 6) to reference to the appropriate date in the past.
But more likely is probably that you want respectively need (you didn't ask directly in this direction) a general resolution of the price-table against your fact-data and with it comes then a connection to the period-fields from a master-calendar. To get something like this you will need to do several additionally things:
This means that now for each date and therefore derived to any needed period-field are directly prices available and you may now apply min/max/avg and/or a count(distinct) and/or a weighted averages logic to show the development of the prices over the time.
Of course it's not a matter of a few minutes else it may require a complete re-design of the data-model + UI from your application but in the long term it would very powerful within the analysis.
- Marcus