Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have included a custom message for a chart as "Please refine your selections to include less data. To view this object, the # of rows should be less than 100,000.". I need to position this custom message to the left most of the chart rather displaying in the center as default.
In the chart set options/layout/
set show condition the same condition as in calculation condition.
Then create a text object with message as in cacluation message and set the show condition in opposite to the chart show condition.
In title:
=if(Count([Trans No]&[Tran Seq])<=65000,'Object title','Please refine your selections to include less data. To view this object, the # of rows should be less than 100,000.')
Hello,
as I know, it is not possible to define the position.
My options are:
- Do not declare the option as calculation option but as object show option and show in case of not fulfilled show a - textobejct with the message
- ohter idea is to show the message in the object header. If fulfilled show object title, otherwise error message.
Regards
- Do not declare the option as calculation option but as object show option and show in case of not fulfilled show a - textobejct with the message
How to do this?
other idea is to show the message in the object header. If fulfilled show object title, otherwise error message
My calculation condition is =if(Count([Trans No]&[Tran Seq])<=65000,1,0). How to show the message in object header
Thanks
In the chart set options/layout/
set show condition the same condition as in calculation condition.
Then create a text object with message as in cacluation message and set the show condition in opposite to the chart show condition.
In title:
=if(Count([Trans No]&[Tran Seq])<=65000,'Object title','Please refine your selections to include less data. To view this object, the # of rows should be less than 100,000.')