-
how to ALTER in-Memory DB table and add new columns?
i have a large model that i don't want to wipe out and rebuild. i was hoping to learn syntax for sql script to "alter table [tableName] Add [tableName].[newColumn] char(8)" type of command.…
- Answered
-
Loading present via URL with filters and targets….but cross model mapping needs to be tailored
I have been expanding a dashboard that’s really resonating with our internal users. When opening the “present” directly it lands with a date filter using “current date”.…
- Answered
-
Re: Can the loading of dashboard with mini-tabs be accelerated to render the current page first while others continue to load in the background?
I have version 2023.11.130 installed. I see that mini-tabs now render the exposed tab quickly and then resolve reasonably when clicking to other tabs (older version appeared to run all tab results in… -
Bad design has left me with database fields that can be populated with comma separated list
Assume my database has the following columns ID DESCRIPTION USERS LOCATIONS I know that ID and DESCRIPTION are always relevant. USERS and LOCATIONS can contain 0, 1,…
- Answered
-
Customizing y-axis settings on Discover with 3 different chart types
my charts render left to right as: stacked bar chart - where I want y-axis start at 0 and auto-max stacked 100 bar chart - where I want y-axis start at 0 max 1 ( or 100%) lollipop chart (would love…
- Answered
-
Time intelligence intervals
my content tends to have times between 9:30am - 4pm displaying charts in hour:minute date part categories would then yield 390 bars. How might i offer users option to see in 1, 2, 5, 15,…
- Answered
-
Can the loading of dashboard with mini-tabs be accelerated to render the current page first while others continue to load in the background?
As I add more tabs for users to self-navigate each incrementally adds to the time users need to wait for data to paint. example a single discover feels almost instantaneous with a button click filter.…
- Answered
-
Where can I configure the IP address or DNS to use for link-back content?
Since we have various VPNs I would like to configure this manually. I have admin access, and more importantly colleagues that can assist with installation and custom configuration, if needed
- Answered
-
Monitoring health of pyramid analytics server and in memory db components- telegraf
Does pyramid analytics connect nicely to any telemetry tools like influxdata’s telegraf? I am hoping to manage and observe the health of pyramid analytics in grafana dashboards where we have a number…
- Answered
-
can pyramid model maintain timestamps with microsecond precision?
i want to down sample a vertica source table via pyramid model "query" to a vertica target table but my microsecond precision timestamps are getting chopped to precision in seconds.…
- Answered
-
Cascading Slicer - show count of elements??
i have a slicer that derives it's elements based on other slicers (and data behind them). how might i expose on a present a field that represents the "count" of elements in the resulting slicer??
- Answered
-
how can i insert a 60 second pause before next iteration of while loop??
assume i need query result from table1 to equal query result of table2 before having a model "process". i thought there might be some sample pql statement that would be similar to "sleep 60" before…
- Answered
-
Models and alternatives to “scheduled” time to process
Outside of pyramid analytics I “know” when my data is available (that my model needs to downsample and append to an memory database) rather than having the model run at specific time of day can I…
- Answered
-
legend location
i like having discovers render "legend" centered on bottom. when i try to add the discover to present or publish i only see legend on left, right, or off as options.…
- Answered
Badges
Latest Posts