Platform Analytics Pivot Table creation with Table data and Formula Indicators

[jstoessel]

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?

[jstoessel]

Adding an additional couple of screenshots to show what I have - these are all built directly from the Incident Table

Now when I go to add an additional Data Source to Select my Formula Indicator - I only see Tables, no Indicators:

Thank you for any nudges into a new direction!!! 

@olgaredkina 

[jstoessel]

Desired outcome (which is currently built with all PA Indicators and collection jobs)

[olgaredkina · Accepted solution]

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

[jstoessel]

Thanks @olgaredkina 

Thank you for the feedback and information.  The challenge I have, which is why I have attempted to move away from full indicators as the solution is the ability to collect the specific data desired.

As our fiscal year started last week - when we are doing the comparison of Last Fiscal Year to This Fiscal Year

When I use indicators  I am not able to use the same "last fiscal year" selection criteria as I can from the table.

I am asked to compare the last fiscal year for the same amount of time that has passed in this fiscal year.

On the table I can use the conditions of:

Closed on Last Fiscal year

and

Closed relative before 365 days ago

When I attempt to use this in an Indicator - it doesn't work correctly.

Again, Thanks for the feedback.  I will consider my options and see what happens!