Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created a chart with several dimensions and expressions. I am attempting to add in a relatively simple expression of =CURRENTPRICE however, when I apply the expression, not data is displayed.
When I add in an aggregation method such as MIN, MAX, SUM, etc. I get data.
Any ideas on where I am going wrong would be helpful. I have attached my data model and below are the dimensions I am using as well as a small sample of what the table looks like
Game Date | Opponent | Tier | Price Scale | Price |
9/15/19 | ABC | 1 | Lower | - |
9/15/19 | ABC | 1 | Upper | - |
9/15/19 | ABC | 1 | Club | - |
9/15/19 | ABC | 1 | Suite | - |
I am assuming you have more than 1 value for CurrentPrice per row. If so that will not display the value and you need an aggregration function
i.e. combination of Game,Opponent,tie,pricescale may have more than 1 currentprice
Game Date | Opponent | Tier | Price Scale | Price |
9/15/19 | ABC | 1 | Lower |
There should only be one CURRENTPRICE per row, based on the Game Date and Price Scale
Do I need to introduce a set expression? If so, what would they structure be?
depends on your data. Share data sample similar to your actual data and i can try and help
Hope this helps
Looking at it i would check your data model. You have multiple columns with values for Price Scale
PPPRICESCALEDESC |
PRICESCALEDESC |
have a feeling something is messed up while you are loading and you haven't modeled it correctly.
Load this data into a sample app exaclty like your load script and share the qvf file if you can
I have them labeled differently so as not to create a synthetic key and/or loop in the script.
Are you using the right column in your table?
Add the CURRENTPRICE column as a dimension and check.
When I add that field (CURRENT PRICE) in as a Dimension, the app generates an error of 'Out of Calculation Memory'