Update my post:
I opted to go for the 2nd PD, the attribute was backfilled and it works good until Error 1003 appears (Too many points in dataset. Current limit is 400. Please modify the query to return fewer points or increase the limit).
I am doing a display with a time range of the whole month updating the value and seems to support only 4 days before overload my symbol.
Need help. ️ ️ ️
Can you tell us about your goal, please? 400 values on screen are already quite overwhelming for the users and it will be very difficult to display all the values in a PI Vision display.
Perhaps we can suggest a path forward if we knew what you are trying to do.
What I want to do was (is) develop a graph as column bars where each bar represents the production of every day, we've got two plants so also we need a stacked columns. We use an analysis on midnight to get this value (was backfilled too), apart from that we should show the value of the current time refreshing as much as possible so at this point I tried to use another attribute that not consume a tag and it was not able to add to the symbol because DataShape: 'TimeSeries' does not allow use attributes with Data Reference: Analysis. I decided to use the attribute as PI Point but as I was using the type query: ModeEvents, then I got 1003 error. The type query was changed to ModePlotValues. The dashboard is under observation.
To be honest, I really don`t know how ModPlotValues and Interval works and it could be fail again, I think.