Two Fields, contained in a Text & Image chart, disappear when the associated Sheet is made Public

[ogatchell]

The two, subject numeric fields figure into a finance report which also contains static text and many more numeric fields. The latter set of numeric fields are dynamic and their values change automatically as data in the App changes; and these field values appear just fine after the sheet is made Public to a User who has Private Analytics Content Creator, Shared Space Creator and Steward rights

The two, subject fields differ from the many additional numeric fields in that they are populated with measures using two separate input variable controls. Once these variable inputs are manually input, their values appear just fine in the Text & Image chart. However, they disappear when the sheet is made Public to the same User.

Can anyone explain the problem and how to fix it?

Thanks in advance!
Oliver

[F_B]

Hi @ogatchell ,

when you are using variables to populate the fields in your chart, these variables may not be initialized properly when the sheet is made public. You can avoid this by setting default values for the variables in the Variable Editor or in the sheet load script. This will ensure that, even when the sheet is public, there are values for the variables to work with.

Hope this helps