- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-10-2024 01:22 PM
I am attempting to create a Pivot Table in Platform Analytics, a task I have successfully done many times before.
The difference this time - I am using columns (data sources) from Tables and want to add a couple of Formula Indicators.
My Example Layout is this:
| Incidents Closed Last Fiscal Year | Incident MTTR Last Fiscal Year | Incidents Closed This Fiscal Year | Incident MTTR This Fiscal Year | MTTR change (LFY-TFY) | % Change MTTR (TFY over LFY) |
| [from the incident table] | [from the incident table] | [from the incident table] | [from the incident table] | [formula indicator] | [formula indicator] |
I have many of these types of formula indicators and was hoping to retire the current PA Indicators and collection jobs so that the calculated fields would completed within PAe.
Am I doing something wrong, or is it not possible to mix Table data and Formula Indicators in a single pivot table?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-12-2024 12:49 AM
Hi @jstoessel ,
At the moment it is not possible to mix different data source types (tables with indicator) in the same chart. Is something that hopefully we will have in the future but now is not supported (that is why once you added table data source you cannot add indicator in additional).
You have 2 options: Option 1 (probably recommended) - move your table queries to indicators as well, so you would have 6 indicators. Or if that for some reason not technically possible you can mix different data sources in technical dashboard by getting data from data resource / API, joining outputs and passing data manually to data visaulization.
Another alternative would be to split in 2 charts, but then you will not get the same outcome and data be more disconnected.
Hope that helps,
Olga
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 weeks ago
Hi @jstoessel
I am trying create a similar table (attached the screenshot of the table). using PA
could you please let me know how you did or any guidance on how to implement the attached screenshot table would be great help
.png){kind=link}