There is any option to switch from one chart to another chart in the same page? like a bookmark?

I want to create a button to switch a chart to MTD and other to YTD for example

Details:

Example: using the "Training Models" database from "In-Memory".
Added tables.

Set up relationships.

Created a discovery.

And added a formula, e.g., a data marker linked to the "Channels" table

In the query preview, the formula works correctly.

Go back to the model and hide the "Channels" table (e.g., in the "Columns" section).

Or hide it in the "Tables" section.

The table disappears from view.

It reappears if you enable "Hidden Tables".

However, the previously established relationships between "Channels" and other tables are gone — they’ve been deleted.

Returning to the discovery, the table appears hidden in the dimensions section. The formula calculation is now incorrect.

No errors show in the formula itself, but the result is wrong.

Is this a bug, or is it by design?

I don't fully understand the purpose of the table-hiding feature if it also deletes relationships. My use case is to hide certain tables from end users, but if existing relationships are removed, it breaks calculations in previously created content.

When the subtotal is displayed in a separate column, why is the subtotal amount repeated on every detail row in the Excel export, even though it appears correctly only at the subtotal level within the report? Is there a way to ensure the subtotal value is exported only on the corresponding subtotal row?

Thanks,

Raveena

I am investigating recurring disk read/write latency spikes on multiple Pyramid in-memory servers.

The storage was moved to a higher-performance network SSD type, but the latency spikes remained.

Monitoring shows recurring write latency spikes, with p99 frequently reaching approximately 150-200 ms, while the number of IOPS and the actual write throughput remain relatively low.

What I observed:

1. The latency spikes occur while the Pyramid in-memory service is running.
2. When the service is stopped, the spikes almost completely disappear.
3. RAM usage remains within the normal range, approximately 40-60%, with no signs of memory exhaustion.
4. Separate fio tests were performed on the same volume while the Pyramid services were stopped.
5. The fio tests did not reproduce the high latency shown in monitoring.

fio results:

Random read:

• Average latency: approximately 0.62 ms
• p99 latency: approximately 2.15 ms

Random write:

• Average latency: approximately 0.59 ms
• p99 latency: approximately 2.06 ms
• Maximum latency: approximately 12.8 ms

No fio errors were reported.

Based on these results, the storage does not show the same high latency under a simple synthetic read/write workload. However, I cannot determine whether the issue is caused by a specific Pyramid I/O pattern or by the way the storage handles this workload.

Could you please advise:

1. Which Pyramid components or background processes can generate this disk I/O pattern?
2. Are there any known issues related to high write latency on Pyramid in-memory servers?
3. Which Pyramid logs or diagnostics should I collect during a latency spike?
4. Is there a recommended way to correlate Pyramid operations with disk latency?
5. Are there any recommended settings for the in-memory service or storage configuration that should be checked?

I have attached the monitoring screenshots and the complete fio read/write logs.

Thanks!

In a Pyramid model, we have an email subscription node configured to send an Excel file to a Box folder using the “Allow uploads to this folder” feature. Although Excel is selected as the output format, the subscription is delivering both an Excel file and an XML file. Why is the XML file being generated, and how can we avoid it?

Thanks,

Raveena

Im facing issues because it split the chart in 2!

Details

You can reproduce this issue using the "Training Models - Sales" dataset. Simply build a table grouped by month with sales amounts.

Save this table. Create a dashboard and add the table to it. Also add a slicer "Date", and in its settings set:

·       Initial Selection Mechanism → Functional

·       Function Type → Last

·       Value → 3 Months

You will see data for the last 3 months, but the figures will be incorrect.

This can be easily verified by adding the "Date" dimension to the table rows.

In the dashboard, you will see that the slicer leaves only one date per month in the table.

I expected to see data for the last 3 months relative to the date specified in the filter.

I am aware that changing the granularity from Date to Month in the calendar settings makes the calculation work correctly. However, this is not very convenient, as it would require manually adjusting the granularity setting each time.

Could you please clarify whether this behavior of the Calendar Slicer is considered correct by design, or is it a bug? Also, are there any workarounds that would allow me to configure the slicer to behave as expected — i.e., selecting a full date range rather than individual dates?

Is it possible to enable multiple selections for a column in a presentation?

Thanks,

Raveena

How to calculate the Average and the Median of the Value? Is this possible at all?
In Excel at least the average could be calculated via SUMPRODUCT(Value, Frequency) / Sum(Frequency) = 100 / 15 = 6.67

2. If you transform the table into an ordered list like this:

How to calculate the Average and the Median of the Value? Is this possible at all?
Would it be possible if the values were a measure?
In Excel you could easily calculate this via MEDIAN(Value) and AVERAGE(Value).

I’d like to report a bug regarding the LLM provider switching process.

We have identified an issue where switching the default AI Engine from an external provider to "Pyramid Internal" causes immediate errors for the current user session. The issue resolves only after the user logs out and logs back in.

Steps to Reproduce:

1. Login to an environment where an External LLM is set as the default (and verified as working).
   
2. Open any Discovery and use the Chatbot to generate a task (it works correctly, creating a report based on the text prompt).
3. Go to AI Settings, change your third-party engine to "Pyramid Internal", and apply changes.
4. Re-open Discovery and repeat the same (previous) command for the Chatbot

Actual Behavior:

• UI Error: Returns "Server Error".
  
• Logs: Record "Error occurred while running the LLM query".
• Persistence: The error persists even after a metadata refresh. It is only resolved by a full logout/login.

Expected Behavior:
The system should process the Chatbot request using the new engine. Changes to the AI provider should apply immediately to the active session without requiring re-authentication.

Pyramid version: 2024.* and 2025.*

Question: 
While logging out and back in resolves the issue temporarily, it would be great if the LLM switch could take effect immediately without logout. What would be the best approach to correct this behavior?

Steps to reproduce:

1. We update the application version on the environment.
2. After startup, the application fails to launch the internal pyramidPrinter process
3. The following error appears every second in the logs: "Can't create process at schedule." (full error text and screenshot are provided below).
4. As a result, the export and print functionalities become completely unavailable.

Temporary workaround:
To resolve this issue, we perform the following manual steps in the terminal:

1. sudo apt-get update
2. sudo apt-get install -y libpangocairo-1.0-0 libx11-xcb1 libxcomposite1 libxcursor1 libxdamage1 libxi6 libxtst6 libnss3 libcups2 libxss1 libxrandr2 libgconf-2-4 libasound2 libatk1.0-0 libgtk-3-0 libgbm1 libxshmfence-dev
3. Navigate to /opt/Pyramid/core/prt/puppet and execute: sudo chmod 777 pyramidPrinter
4. Navigate to /opt/Pyramid/core/prt/puppet/chromium and execute: sudo chmod 777 chrome
5. Return to /opt/Pyramid/core/prt/puppet/ and execute: ./pyramidPrinter --tabs=1 --port=3002
   Once the PUPPET-INITIALIZED message appears, press Ctrl-C.
6. Restart the Task Engine service either via the web interface or by command: sudo systemctl restart pyramidTE

This approach is highly inconvenient and poses a critical blocker for us: all manual changes must be reapplied after every single application update, and during these actions, the affected functionality becomes unavailable.

Are there any other ways to resolve this issue permanently?

Full error text and screenshot:

"Can't create process at schedule

Can't create process core/prt/puppet/pyramidPrinter --port=10000 --proxy="{\"enableProxyServer\":false,\"useCredentials\":false,\"bypassProxyServerLocal\":false,\"proxyServer\":{\"address\":\"\",\"port\":0},\"loginUser\":{\"inheritanceType\":\"LoginUser\",\"name\":\"\",\"password\":\"\"}}" --localProxyPort=15000 --tabs=4 --uuid=df777382-4f10-4bb8-8b85-a61976041d8d at /opt/Pyramidtype: PROCESS_START_DEAD,

com.pa.infra.extProcess.launching.EndlessProcessesLauncher.launchEndlessProcess(EndlessProcessesLauncher.java:20)

bl.printingEngine.managers.PuppeteerProcessesManager$1.createObject(PuppeteerProcessesManager.java:84)

bl.printingEngine.managers.PuppeteerProcessesManager$1.createObject(PuppeteerProcessesManager.java:68)

com.pa.infra.extProcess.ProcessPool.callCreateObject(ProcessPool.java:414)

com.pa.infra.extProcess.ProcessPool.changeAvailableProcessesSizeToIdealSize(ProcessPool.java:259)

com.pa.infra.extProcess.ProcessPool.periodicRun(ProcessPool.java:200)

com.pa.infra.extProcess.ProcessPool.lambda$new$1(ProcessPool.java:71)

pyramid.infra.core.context.PaCallable.call(PaCallable.java:18)

java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)

java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)

java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)

java.base/java.lang.Thread.run(Thread.java:1583)"

 

After upgrading to version 2025.10.005, the server_log_requests system table no longer records any entries.
I checked the administrator console but couldn't find any relevant setting to re-enable it.

Could this be a known issue? Is there a configuration parameter we need to set manually, or has the logging mechanism changed in this release?

I have a question about Date/DateTime export behavior in Pyramid.

After additional testing, I found the following behavior:

If a Date/DateTime field has a model-level format suitable for Excel, for example yyyy-mm-dd or MM/DD/YYYY:

1. When exporting to CSV, Excel can recognize the exported values as dates.
2. When exporting to Excel (.xlsx), the same values are not recognized as dates and are treated as text.

This looks inconsistent, because XLSX supports native date/datetime cell types, while CSV is only a text-based format.

Is this expected behavior for Excel export in Pyramid?

Expected behavior:
When exporting to Excel, Date/DateTime fields should be exported as native Excel date/datetime values, not as plain text.

This would allow me to:

1. Sort values as dates.
2. Use Excel date filters.
3. Use date formulas without manual conversion.
4. Build pivot tables using these fields as real dates.

Could you please confirm whether this is expected behavior, a known limitation, or something that can be treated as an export issue?

Thanks!

I'm using the forecast feature in Discover. It shows a line chart, and for the forecasted periods it displays confidence intervals. Is there a way to show those confidence interval values in a crosstab, the way they appear in other charts?

I am currently trying to create some layered maps in Discover that overlay store location bubbles on top of an area map. Unfortunately, it seems like layered maps do not support using latitude and longitude measures to plot data points on the map like bubble map charts do. This then means reliance on Geocoding or predefined address, city, etc. attributes which are less reliable. I'm guessing this is because the layered map is missing the 'Details' drop zone that the other map visualisations have.

Is there any way to get latitude and longitude measures to work with layered maps or does this feature not exist?

Many thanks

For example: street address line 1, street address line 2, City, State, Region, Zip code

I'm trying to navigate to a specific slide in a Present Pro dashboard using Execute JavaScript action (not Jump To Slide). I wanted to share everything I've tried so far in case anyone has a solution.

What I want:

• When a user clicks a button, if their role is Admin → go to slide 2
• If not Admin → show an access restricted popup

What works:

• Contains(UserRoles(), "Admin") → role check works perfectly
• The popup for non-admins works fine
• "alert('test')" → works
• "document.dispatchEvent(new KeyboardEvent('keydown', {key:'ArrowRight', keyCode:39, bubbles:true}));" → goes to next slide (one slide forward only)

What doesn't work:

• pyramidApp.present.goToSlide(2) → nothing happens (this was working till Sunday Night)
• pyramidApp.present.nextSlide() → nothing happens
• pyramidApp.present.goToPage(2) → nothing happens
• pyramidApp.navigateToSlide(2) → nothing happens
• pyramidApp.present.navigate(2) → nothing happens
• window.postMessage({type:'nextSlide'}, '*') → nothing happens
• document.querySelectorAll('.tab-header-item')[1].click() → nothing happens
• document.querySelectorAll('.tab-header-hotbox')[1].click() → nothing happens
• Dispatching ArrowRight twice with setTimeout → only goes one slide forward

DOM findings:

• No <button> elements found in Pyramid's DOM
• Found .horizontal-arrows-scroller with child classes: tab-header-hotbox, tab-header-item, tab-text, selected
• Clicking these elements programmatically does nothing

Question:
Is there any JavaScript API or DOM method available inside Pyramid's Execute JavaScript action to navigate to a specific slide by number?

The goToSlide() method in the docs only works for the Embed API (EmbeddedResult), not inside internal JS actions.

Any help or workaround would be greatly appreciated!

Thanks

Values: ```json
{
  0: {
    "value": 26000000
  },
  1: {
    "value": 38000000
  },
  2: {
    "value": 65000000
  },
  3: {
    "value": 83000000
  },
  4: {
    "value": 126000000
  },
  5: {
    "value": 126000000
  },
  6: {
    "value": 47000000
  },
  7: {
    "value": 67000000
  },
  8: {
    "value": 331000000
  }
}
```

Background

I have a receiving ledger with a few million rows of receiving entries. Each row contains the usual fields:

·         Purchase order number

·         Part number

·         Received date

·         Unit price

·         Received quantity (QTY)

Goal

I want to track price changes for each part and the resulting dollar impact over a user-selected time period. In the discovery, the user picks a start period and an end period based on the Received date.

How the calculation should work

The base (initial) price is the first price paid for a given part on or after the selected start period. Any later price change is shown as a delta from that initial price:

Price difference = Current price − Initial price

The dollar impact is then weighted by the received quantity:

$ Impact = Received QTY × Price difference

What I’ve tried

I can build every calculation without trouble except for selecting the initial price based on the user’s filter selection. Using a Lag or a previous member approach does not reproduce the result I’m after, because the initial price needs to be anchored to the first record within the selected window rather than the immediately preceding row.  Moreover, it should consider any other filter in the discover, such as the Part number selected.

My question

How can I create a variable initial price that is driven by the date range the user selects on a filter — i.e., the first unit price per part within the chosen start/end period — so the delta and impact recalculate as the filter changes?

Thank you 

DG

GENERATE({ @DateRange }, { ParallelPeriod([Book Date].[Hierarchy].[Year], 1, [Book Date].[Hierarchy].CurrentMember) })

This would loop through all the dates in the parameter and go back to the same periods in the previous year.  I'm not sure how to do something similar in PQL.

For example, I want to show a report that compares the data for dates 1/1/26 through 5/31/26 to data for 1/1/25 through 5/31/25.  

 How would I do this in PQL?

I can reproduce a UI crash in Model when opening the settings window for an Unpivot node.

Scenario:

ClickHouse > Table > Unpivot

Steps to reproduce:

1. Create a new model.

2. Add a ClickHouse source.

3. Select a table from the ClickHouse source.

4. Add an Unpivot node after the Table node.

5. Select the Unpivot node.

6. Click Settings in the Unpivot properties panel.

1.

 2.

 Expected result:

The Unpivot settings window opens and I can configure the node.

Actual result:

The settings window starts loading, then the whole Model screen turns gray. The interface does not recover. The only way to continue working is to refresh the browser page.

The issue is reproduced when clicking Settings for the Unpivot node. I will attach screenshots showing the model flow before clicking Settings and the gray screen after clicking it.

Source type: ClickHouse
Flow: ClickHouse > Table > Unpivot
Pyramid version: 2025.10.005

Thanks

How Pyramid Analytics is different from other tools/technologies available in the market? like Power BI or Tableau or Oracle BI?

What are the unique features that makes PA is more powerful than other tools?

getFormula

It claims to return the PQL or MDX representation of the formulate object. There is no sample of what the output looks like so I am wanting some confirmation that this is what I want before figuring out how to implement the code.

For example, let's say I have a custom formula/measure that is defined as a ratio and was built in Formulate using the Growth template in the Marketplace (A-B)/A. Would this API call return the actual column names seen in the Syntax Preview?

I have measures in my publication that display values as $0. When I export the publication to Excel, the values appear as just $ without the 0. I have attached screenshots of both the publication view & the exported Excel view. How can I fix the zero missing in the Excel export.

Thanks,

Raveena

I am looking for recommendations on how to proactively identify Pyramid content that may overload runtime servers.

I had a case where opening a specific content item caused very high memory usage on runtime servers. The runtime machine became almost unresponsive because of memory exhaustion, and requests routed to that runtime started hanging.

My question is about prevention. I want to understand how an administrator can find this kind of risky or inefficient self-service content before it affects the environment.

Questions:

1. Are there built-in admin tools, logs, audit data, repository queries, or monitoring views that show which content items consume the most memory on runtime servers?

2. Is there a way to identify reports, dashboards, or models that create very large intermediate result sets or expensive runtime queries?

3. After a runtime overload event, is there a recommended way to identify which content item caused the memory spike?

4. Are there recommended limits, alerts, or isolation settings that can prevent a single heavy content item from overloading runtime servers?

5. What is the recommended process for reviewing and optimizing this type of content in self-service environments?

The goal is to detect and review this type of content in advance, before it overloads runtime servers.

Pyramid version: 2024.03.002

Thanks

Here is a simplified example:

Rows 1-5 are from Discover 1

Row 6 is a simple Sum Total

Row 7 is coming from Discover 2 on sheet2

Row 8 is Row 6 divided by Row 7

This part is working as expected.  I can change the slicer and it returns the correct data.  The problem is when I drop it in a dashboard.  The slicer in the dashboard, which I pulled from the Tabulate, is not changing the data even though the breadcrumb is showing that the value is being passed in.  I’m sure it is something I missed in configuring either the slicer in Tabulate or the Visual Area.  Do I need to create parameters? Should I not include a slicer in the tabulate? How do I get the dashboard and tabulate to communicate?

We are currently using a matrix-format report with subtotals in Pyramid Analytics. However, when exporting the report to CSV, the columns become jumbled/misaligned because the matrix layout is flattened during the export process.

We would like to retain the matrix format and subtotal structure while exporting. Are any export settings, formatting options, or recommended approaches to preserve the matrix layout in the CSV output?

Thanks,

Raveena

We have written the following formula to count the number of active users:

Code-Snippet
Count(
Filter(
allMembers([Nutzer].[Benutzer ID]),
([Nutzer].[Benutzerstatus].[1], [measures].[Login Anmeldung ID]) > 0
)
)
The problem is that when we select multiple months in Discover, this formula always aggregates the individual values of both months together instead of splitting them by month.

For example, we have 135 active users in February and 147 in March. However, when I select both months simultaneously in the Discover filter, the formula no longer outputs separate values for each month. How can I adjust this formula to respect the monthly breakdown?

I encountered an issue with SQL Script node in the Master Flow.

Steps to reproduce:

1. Create new model and dataflow
   In our case it’s a simple dataflow from excel file to an In-Memory database

   

2. Open Master Flow

3. Add “SQL Script” and “Data Model” nodes and connect them to the Data Flow

   

4. Configure SQL Script node to access In-Memory DB and choose any available DB

5. In the SQL Script node write query: “SELECT 1”

   

6. Add new Variable in the following manner:
   Change Data Type to “Date” and activate checkbox “List”

   

7. Press Validate or Process Model

I get an error: «java.lang.NullPointerException: Cannot invoke "java.time.LocalDate.format(java.time.format.DateTimeFormatter)" because "date" is null»

If I remove the variable, or deactivate the "List" checkbox, or delete the SQL Script node, the flow is considered correct.

Thanks!

Steps to reproduce:

1. Create new Matrix Grid with said hierarchy, column and measure

   

2. Create new presentation with the created Matrix Grid
3. Open presentation as a viewer
4. Quick Sort the matrix by measure (Sum Cost - in my case)

   

    
5. Expand any Category (in my example – Furniture)

Actual behavior:

Sub-categories are not under the expanded Category, but are sorted like independent rows (The hierarchy is broken).

Desired behavior:

Each Sub-Category is under the expanded Category

Note that in Discover, the «Break Hierarchies» checkbox can be disabled to achieve desired behavior, but a viewer can’t disable it while in presentation mode.

Thanks!

I found an issue with renaming objects in the Search panel.

Steps to reproduce:

1. Select any object in the Explorer, open its Metadata panel and copy its Item ID

   

2. Reload the browser page

3. Without opening the object in the Explorer, navigate to Search, paste copied Item ID into the search bar and press Search

   

    

4. Right-click the object, click rename and type in new name

   

5. Press the Search button again or press Clear and perform step 3 again

Expected behavior:

Search result shows the object with the updated name

Actual behavior:

Search result shows object with the old name

I also found out that there is no issue if the object has been opened in Explorer after the page reload.
 

Thanks!

 Can anyone tell me what I am doing wrong?

Thanks!

I need help creating Previous Month Sales, Current Month Sales, and Growth % in a Pivot.

I have:

• A Sales column

• A Sales Date column in yyyy-MM-dd format

Initially, I created a custom Month column, and the calculation was working correctly. However, when I tried using the actual Sales Date column directly, it stopped working.

I have already tried using Lag() and the Previous option, but it is still not giving the expected result.

My requirement in the Pivot is:

1st Column = Previous Month Sales
2nd Column = Current Month Sales
3rd Column = Growth %

Also, I need the values to be dynamic according to the Sales Date filter selection.

The Sales Date will be used in the filter.

Could someone please suggest the correct way to achieve?

Thank you!

Is it possible to create a group folder for an existing role? We are currently restructuring our folders and want to avoid creating new roles or deleting existing ones. Doing so would require us to update the roles in the public folders as well, which is highly error-prone.

Creating a new Role:

 
customising an existing folder:

Thank you in advance for your help.
Jona

Can we enable a specific email template for one workgroup without making it the default for all workgroups?

Thanks,

Raveena

Is there a way to remove the border in mini-tab.

Thanks,

Raveena

How can I group in the report some elements? I have a field with A, B, C, D, E and F, and I want to create an extra field with value XX when field 1 is a, B or C, and value ZZ when field 1 is D, E and . 

Does Pyramid Support MHTML files if so how we can retain the format?

Thanks,

Raveena

"Our technical support team primarily handles bugs and issues related to the Pyramid application. 
Since your inquiry concerns the Learning Hub, we recommend contacting the LMS team at learninghub@pyramidanalytics.com for assistance.

In the meantime, we will proceed with closing this support case. 
However, if you do not receive a response from the LMS team or need further assistance, please feel free to reopen the case." 

It's Wednesday and he still hasnt been helped, what is the process to receive help?

Can we configure an action on a Present so that, when it navigates to a Discover via actions, the slicers are passed through as columns in the destination Discover?

Thanks,

Raveena

I want to collate multiple discovers onto a single page and export them into one Excel file. The export should appear as shown here, where each table represents a separate discover.

 I tried adding all the discovers into a presentation slide, but when I export, they end up in different sheets. How can I achieve the desired output shown above?

Thanks,

Raveena

I want to collate multiple discovers onto a single page and export them into one Excel file. The export should appear as shown here, where each table represents a separate discover. I tried adding all the discovers into a presentation slide, but when I export, they end up in different sheets. How can I achieve the desired output shown below.

Thanks,

Raveena

I am trying to export a Publication to Excel and want to maintain the layout of my page. Specifically: I have three reports/grids on a single Publication page, but when exporting to Excel, Pyramid creates three separate worksheets (tabs) instead of putting everything onto one single sheet.

What I have already tried without success:

• Grouping: Grouped all visuals on the page.

• Export Settings: Checked "Merge Common Cells" and toggled various Slicer options.

My Goal: The content of one Publication page should result in exactly one Excel worksheet, preserving the vertical arrangement of the reports.

Is there a specific setting or a "Layout-Fidelity" toggle I am missing to force Pyramid to treat the page as a single export entity?

Thanks for your help!

I found an inconsistency between the PQL documentation and the actual behavior of DateDiff in a Custom Column.

https://help.pyramidanalytics.com/2024/Content/Root/developer/reference/fx/PQL/Common/Date-Time/DateDiff.htm?Highlight=datediff

According to the documentation for DateDiff, the supported flag for days is:
- "dy"
- "dayofyear"

However, when using this in a Custom Column, the following expression fails:

DateDiff(last_login_date, now(), "dy")

Error:
Unsupported date offset type: dy

At the same time, the following expression succeeds:

DateDiff(last_login_date, now(), "dd")

The issue is that "dd" is not mentioned in the documentation, while the documented "dy" does not work in this context.

Expected behavior:
- either "dy" should work as documented,
- or the documentation should be updated to reflect the actually supported flag values for this function in Custom Columns.

This looks like either a documentation issue or an inconsistency in the function implementation for Custom Columns.

Screenshots attached.

 Thanks.

my aim is to map a slicer over two different models. One is a OLAP Cube and the other one a InMemory model.

In both models I use the exact same Slicer "Buchungskreis ID" 

 And also the Elements are the same.

 When I try to map two simple test reports in a dashboard the slicer does not interacte with both.

Can someone help me out here? I also attached a PIE file of the Dashboard 

Thank you in advance,

Jona

CASE(
    CONTAINS([product], “Checking”), “Checking”,
    CONTAINS([product], “Savings”), “Savings”,
    CONTAINS([product], “CD”), “CD”,
    CONTAINS([product], “Auto”), “Auto Loan”,
    CONTAINS([product], “Loan”), “Loan”,
    CONTAINS([product], “Fixed”), “Loan”,
    CONTAINS([product], “Business”), “Business”,
    “Other”
)

We have a dashboard with a slicer for cost centres. The sales organisation should cascade on this so that only the cost centres of the selected sales organisation are shown.

We have currently incorporated the cost centres as a drop-down slicer. However, this is not ideal, as there are several levels in the selection that are not easily visible to the user without the hierarchy being displayed. 

 
If I change the type of slicer to a multiple tree selection, the box (marked in red) where I can tick the cascade option disappears. Why is that? 

As always: thank you for your help!
Jona

1. "SALES by PRODUCT CATEGORY" as stacked column on the primary Y-axis
2. "MARGIN" as line chart on the secondary Y-axis

So, it should look like this...

 ...but the PRODUCT CATEGORY (Color drop zone) should only have an effect on SALES, not on MARGIN. So, I want to have ONE line chart for the overall margin. 

(How) Is this possible?

THNAK YOU!!!
Micha

Hi PA team,

We would like to implement the following calculation:
We have a list of products, and we want to create a distinct count of these products.

However, for this measure, we would like the results to not be affected by the product color filter when used in a dashboard KPI or in a Discovery canvas.

In our data model, Product ID and Color are in the same table, and in Power BI there is an option to use REMOVEFILTERS inside CALCULATE to ignore specific filters for a measure.

Our question is:
👉 How can we implement similar functionality in Pyramid Analytics?
We have checked the community resources but could not find an equivalent option.

Thanks in advance for your support.