new Dimension created by master item

[yechiela]

Details & Context

1. Creation Method: I created the new time dimension directly on a sheet and saved it as a Master Item (Dimension).

2. Dimension Name: 3 sec (as seen in the screenshot attached).

3. Dimension Formula: The dimension is a calculated field based on the base date/time field DateUtc.

   • Formula: =Time(Floor(DateUtc * 24 * 60 * 60 / 3) * 3 / (24 * 60 * 60), 'hh:mm:ss')

4. Publishing Status:

   • The Sheet containing the chart is published.

   • The App is published to a Shared Stream.

5. User Experience: Other users see the chart object and the dimension labels (3 sec), but the chart body is completely blank or empty.do you know why?thx 

[Or]

Never create master items in a published app. It always ends poorly. I'd recommend deleting it and creating it in an unpublished copy, and then republishing. 

[yechiela]

 thx ! 

i add the new Dimension   (Time(Floor(ConvertToLocalTime(DateUtc,'Jerusalem') * 24 * 60 * 60 / 10) * 10 / (24 * 60 * 60), 'hh:mm:ss') AS Time_10SecInterval,) in the data editor under section and and update to the sheet but still the user not  see it  what i missing ?

[Or]

I'm not sure what you're referring to. This doesn't read like a master item, it reads like a script line. 

You need to:

1) Duplicate the app

2) In the copy, create your master item

3) Republish the app

[yechiela]

Hi thx this what i do the new master item "Time_10SecInterval" and its work for me but when i publish chart with this Dimension    the user saw empty chart  

[Or]

This may be related to the dimension you previously created in the published application under the same name. Have you tried using a different name for the new one?

[yechiela]

yes ,It seems that the new dimension has permissions for users to see it or something like that, because every change I make they see and every graph with this dimension goes where

[Or]

Well, I'd suggest just giving up on the original name, then. Creating a dimension in a published application is not a good idea at all, and I have no idea how to safely undo the effects (not sure anyone does).

Assuming you've enabled the option to create master items in published apps via security rule, I would advise you fix the security rule to prevent this in the future, but that part is up to you.