Latest Activity

custom visual access restriction

I am preparing a custom visual to show list of all the dashboards shared with the particular user group folder lying inside workgroup content folder. I need help in setting up restrictions within…

Can I have list of all the cshids used to divert help button

Hide or Unhide Slicers

Hi, Does anyone know of a way dynamically hide/ unhide slicers. I have a report where a user has multiple optional slicers e.g SKU Code, Barcode, Secondary SKU Code or Product Description.…

• Answered

Best Practice for a "Read-Only" Pro User in a CI/CD Environment

Hello PA Team, I'm looking for a best practice or architectural advice for a common CI/CD scenario that I'm struggling to implement. I need to configure a Pro user profile for my production…

Changing the background or font of 1 cell

I have a table jam packed with information, but I need 1 cell (in my case it is a specific element within a dimension) to have a red background. How do I go about doing that?

Binary Code to HTML in Pyramid

We have a BINARY column in Snowflake that contains file data in raw bytes . This column is being surfaced in our Pyramid data model. Can Pyramid natively convert this binary field into a renderable…

• Answered

End of Month custom column (EOMONTH formula)

Is there way to convert dates to End of Month date using formula like EOMONTH. In our system, we do not load data for Sundays or Holidays and I would like to use the EOMONTH formula to convert any…

• Answered

"Last N Weeks" Function in Calendar Slicer is Misleading

Hello PA Team, I'm reporting a highly confusing behavior in the Calendar Slicer that appears to be a UI/UX bug. Steps to Reproduce: In Discover, add a date hierarchy to the Filters zone to create a…

Minimum Date

Hi all, I'm looking to find the first time a customer quoted. I have a transactional table with customer dimension and a quote date dimension. I want to aggregate the dates by customer and return the…

• Answered

Is there a way to show a measure only once when we have repeating dimension values?

We have a scenario where an insurance policy has multiple drivers. However, there is only one insurance premium at the policy level. If we add drivers to a discovery with a measure it replicates the…

• Answered

Using Regular Expressions to replace

Hello, Is there a way to use regular expressions to search and replace?

• Answered

PYTD vs YTD Comparison , while Not Showing Dates

I have a request which i cannot seem to get working correctly without showing dates. I want to compare suppliers YTD spend vs PYTD spend, so only dates up to today for this year and last.…

• Answered

Truncating decimal numbers in dimensions

I have a custom model that has currency exchange rates; the rates are decimal numbers with 4 places, in the sql query I have them truncated to only show 4 places In some of my discoveries,…

• Answered

Disabling "Panel Tools" for Individual Visualizations

Hello, PA team! I would like to be able to hide the "Panel Tools" for only one or more visualizations on a presentation slide, for example, have "Panel Tools" for one visualization and none for…

• Answered

Move the rows header column to the right?

Can I move the rows header to the right side?

• Answered

How do I upload my corporate font?

We have a corporate font, which isn't available on the standard fonts lift in Pyramid. How do I add it? It's on my computer, but not available on Pyramid.

• Answered

Execution Solve Order Explanation

Morning all, Question around formulates and solve orders, we have had a couple of situations recently that has caused some issues that was resolved by adjusting the solve order on formulates.…

• Answered