As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at email@example.com and provide your corporate email address, company, and name.
I have a heatmap where via auto-prompted parameters that user can change the measure and change the X and Y axis dimensions.
The Y Axis and X Axis are setup the same, with the code for the Y Axis as follows:
BY &RP_FL02B01_Sort2.( <Business Line,J2.INVOICES.BUSINESSLINEDESCRIPTION>,<Conglomerate,CLIENTS.CLIENTS.DEFConglomerateDesc>,<Client,CLIENTS.CLIENTS.CLIENTNAMEANDID>).Select Breakdown.
All this works fine, but I need to change the labels to reflect their selection. I believed the way to achieve this was by altering the above code as follows:
BY &RP_FL02B01_Sort2.( <Business Line,J2.INVOICES.BUSINESSLINEDESCRIPTION AS 'Business Line'>,<Conglomerate,CLIENTS.CLIENTS.DEFConglomerateDesc AS 'Conglomerate'>,<Client,CLIENTS.CLIENTS.CLIENTNAMEANDID AS 'Client'>).Select Breakdown.
This in fact works when I execute the chart. However, it apparently breaks something as I am no longer able to open this in the App Studio GUI, as I get an error stating "The following field was not found. J2.INVOICES.BUSINESSLINEDESCRIPTION A S 'Business". The rest of the message was cut off. It then asks me if I would like to select a different field, the result of which is that I am presented with a field list.
I then attempted achieve this by entered the following under *GRAPH_JS_FINAL
My plan was to replace the actual text with a variable that I would set based on user selection. However, while the above changed the xaxis label it does not change the yaxis label. Why it works for one and not the other I cannot say.
In any event, I am at a loss. Any help is appreciated.
Thanks allThis message has been edited. Last edited by: FP Mod Chuck,
WebFocus Server 8.2.01M WebFocus App Studio 8.2.01M Windows Server 2012 R2 Standard All Outputs