Mark Oldfield's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: `itemId` Parameter for `dataSources/addRolesToItemAndBubbleUp` API
Hi Raveena, The APIs are well documented with both the input and output parameters being defined in our online help For your example, you can find the parameter definition here https://help.…
- Principal Customer Solutions Consultant
- Mark_Oldfield.1
- 3 wk ago
- Questions & Answers
- Reported - view
Re: Maps in Pyramid
Hi James You can find the custom geospatial shapes that you may require here. https://data.humdata.org/dataset/cod-ab-ken? thanks Mark
- Principal Customer Solutions Consultant
- Mark_Oldfield.1
- 2 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Dashboard Gallery: Bourbon Selection
@Michael Daun Please login into the Explore server, this content should now be available to you—many thanks for bringing this to our attention.
- Principal Customer Solutions Consultant
- Mark_Oldfield.1
- 3 mths ago
- Pyramid Dashboard Gallery
- Reported - view
Re: including google charts in Formulate ( custom visual )
Hi @Ajay SampathKumar In addition to the above resources, there is an article on Custom visuals in our community forum here. https://community.pyramidanalytics.…
- Principal Customer Solutions Consultant
- Mark_Oldfield.1
- 5 mths ago
- 1
- Questions & Answers
- Reported - view
Re: How to show URL icons in matrix grid?
What a great approach, I've placed a copy of this ingenious approach of using Dynamic text here on our Explore server environment so you can see this example first-hand.…
- Principal Customer Solutions Consultant
- Mark_Oldfield.1
- 5 mths ago
- Questions & Answers
- Reported - view
Re: How to show URL icons in matrix grid?
Hi @Aaron Yohannan in your data model definition (within model pro), you need to define the category of the attribute you wish to be shown as an image as 'Image URL', note:…
- Principal Customer Solutions Consultant
- Mark_Oldfield.1
- 6 mths ago
- Questions & Answers
- Reported - view
Re: Data Model - summarize column, unique row
Hi @Tabitha DeCaprio I would see this more as a logical data model challenge initially, looking at your data I think it's represents the below:- the left-hand side represents what you currently have,…
- Principal Customer Solutions Consultant
- Mark_Oldfield.1
- 6 mths ago
- Questions & Answers
- Reported - view
Re: Rolling average formula
Hi @Katie Easton The example above is using MDX (as Im assuming it is connecting to an MS tabular/olap model with the use of the IIF) , instead of trying to see where Lag(1) = 'NULL' you can use the…
- Principal Customer Solutions Consultant
- Mark_Oldfield.1
- 6 mths ago
- 3
- Questions & Answers
- Reported - view
Re: Forecasting Label
@Tamizhanban K the currently supported options are a label that is customizable with a counter ... i.e. forecast 1 , 2 ,3 or the AI captions which match the rest of the entries logically.…
- Principal Customer Solutions Consultant
- Mark_Oldfield.1
- 6 mths ago
- 2
- Questions & Answers
- Reported - view
Re: Forecasting Label
Hi @Tamizhanban K My colleague @Angelie Janssen made a great post on this very topic here https://community.pyramidanalytics.com/t/x2y32qb/how-to-use-ai-driven-forecasting-captions you can also find…
- Principal Customer Solutions Consultant
- Mark_Oldfield.1
- 6 mths ago
- Questions & Answers
- Reported - view
Re: How to apply borders, based on grouped columns
@Vijayan Krishnan without knowing the exact use case above, Im assuming that when you apply a grid line (or other formatting) to a parent member it affects its children.…
- Principal Customer Solutions Consultant
- Mark_Oldfield.1
- 6 mths ago
- Questions & Answers
- Reported - view
Re: How to apply borders, based on grouped columns
Hi @Vijayan Krishnan To add to this for your specific example the best way to approach this is to remove the existing grid by selecting 'None' then select the 'Expense' column and select the 'Left'…
- Principal Customer Solutions Consultant
- Mark_Oldfield.1
- 6 mths ago
- 1
- Questions & Answers
- Reported - view
Re: What is the maximum size for a text variable?
Hi @Daniel Van Wyk The 2 approaches you could use are either putting a Python script into your flow (with the option to create a new table if applicable),…
- Principal Customer Solutions Consultant
- Mark_Oldfield.1
- 7 mths ago
- Questions & Answers
- Reported - view
Re: What is the maximum size for a text variable?
Hi @Daniel Van Wyk Have you tried to use the JSON file source as a source within a data flow instead, this is more aimed at receiving a JSON data payload, where a web application API is one use-case,…
- Principal Customer Solutions Consultant
- Mark_Oldfield.1
- 7 mths ago
- 2
- Questions & Answers
- Reported - view
Re: Filter Selected Date
Hi Immanuel, The scenario would require a model parameter (based on the date attribute you wish to filter) and then this parameter could be used to generate a list of dates as a range,…
- Principal Customer Solutions Consultant
- Mark_Oldfield.1
- 7 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Report URL Options
Hi @Vaughan van der Merwe Unfortunately, I can't think of an alternate approach as the approach implemented is the method that Chrome (and other browsers ) use to open URL links in a new window.…
- Principal Customer Solutions Consultant
- Mark_Oldfield.1
- 8 mths ago
- Questions & Answers
- Reported - view
Re: Has anyone used Pyramid with Dynamics (D365 - FinOps and CE) ?
Hi @Richard Varley I would look at CData's connectors to get the ability to extract the data from MS Dynamics https://www.cdata.com/drivers/dynamics365/jdbc/ This can then be added as a custom…
- Principal Customer Solutions Consultant
- Mark_Oldfield.1
- 8 mths ago
- Questions & Answers
- Reported - view
Re: Report URL Options
As an alternative to having the URL link as fields with a URL type, would it be possible to perform the same using an Action using 'Jump to URL' in a discovery?…
- Principal Customer Solutions Consultant
- Mark_Oldfield.1
- 8 mths ago
- Questions & Answers
- Reported - view
Re: Exploration empty in a publication
Hi @Aurelie , the page trigger is for all the items on a page. The input of the trigger is a discovery and the metrics created by a KPI can be placed into this discovery further details on the…
- Principal Customer Solutions Consultant
- Mark_Oldfield.1
- 8 mths ago
- Questions & Answers
- Reported - view
Re: Exploration empty in a publication
Hi Aurelie, You could implement a page trigger to control when a page is produced within your publication. For your use case you could check to see if a discovery contains data,…
- Principal Customer Solutions Consultant
- Mark_Oldfield.1
- 8 mths ago
- Questions & Answers
- Reported - view
Re: Connecting to Tidal software to get the job data and display batch status in Pyramid.
Hi Prakash, I'm assuming it is the Tidal software that Christian has linked to in his reply. Tidal Software look to provide a rich API interface to its product,…
- Principal Customer Solutions Consultant
- Mark_Oldfield.1
- 10 mths ago
- 1
- Questions & Answers
- Official response
- Reported - view
Re: How to Create a Slider Filters
Hi @Vijayan Krishnan The 'Between' filter example I provided creates 2 global parameters for the 'From' and 'To', with the initial example showing 2 text boxes, alternatively,…
- Principal Customer Solutions Consultant
- Mark_Oldfield.1
- 11 mths ago
- 1
- Questions & Answers
- Reported - view
Re: How to Create a Slider Filters
Hi@Vijayan Krishnan , To achieve the functionality of filtering a range based on the available measures within a Discover you can use the Quick Filter functionality.…
- Principal Customer Solutions Consultant
- Mark_Oldfield.1
- 11 mths ago
- Questions & Answers
- Reported - view
Re: Waterfall Chart to show the actual growth split by category
@Christian Langmayr @Natalie-Anne Botha this approach fits the use case perfectly. The IBCS Waterfall chart uses 2 value fields for the waterfall, a 'from' and a 'to'.…
- Principal Customer Solutions Consultant
- Mark_Oldfield.1
- 11 mths ago
- 1
- Questions & Answers
- Official response
- Reported - view
Re: Question on How to use Measure Lists and Parameters
Hi Natalie, A Measure parameter does not support multi-select as a parameter in this scenario represents a single measure. A Measure List can hold multiple measures and the approach you could take is…
- Principal Customer Solutions Consultant
- Mark_Oldfield.1
- 11 mths ago
- 1
- Questions & Answers
- Official response
- Reported - view

1 2

Back to top

Home

Questions & Answers

View all topics