Filter on type hidden not working
Mapping for ProjectId is set to type: hidden
by RainerAtSpirit
HTML
<link rel="stylesheet" href="https://s3.amazonaws.com/flexmonster/2.3/demo.css">
<script src="https://cdn.flexmonster.com/flexmonster.js"></script>
<div id="pivot-container">The component will appear here</div>
JavaScript
var pivot = new Flexmonster({
container: "pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
toolbar: true,
report: {
dataSource: {
type: "json",
data: getData(),
},
mapping: {
Id: { type: "id" },
Title: { type: "string" },
ProjectId: { type: "hidden" },
ProjectTitle: { type: "string" },
EmployeeName: { type: "string" },
PlannedHours: { type: "number" },
ActualHours: { type: "number" },
FunctionalArea: { type: "string" },
Level1: { type: "string" },
Level2: { type: "string" },
Level3: { type: "string" },
},
slice: {
reportFilters: [
{
uniqueName: "ProjectId",
filter: {
members: [
"projectid.[07a23cd0-77f8-4fcf-aa71-5e9d07b33cf8]",
"projectid.[0e8d4082-03be-40ce-938a-1898afb821a0]",
],
},
},
],
rows: [
{
uniqueName: "Level3",
},
],
columns: [
{
uniqueName: "[Measures]",
},
],
measures: [
{
uniqueName: "ActualHours",
aggregation: "sum",
},
{
uniqueName: "PlannedHours",
aggregation: "sum",
},
],
},
conditions: [
{
formula: "#value > 50000",
format: {
backgroundColor: "#FFFFFF",
color: "#FB8C00",
fontFamily: "Arial",
fontSize: "12px",
},
},
],
version: "2.8.6",
creationDate: "2020-05-14T10:57:11.505Z",
},
height: 600,
});
function getData(){
return [ { Id: '3aaa0129-5d2a-46b2-a6c1-0a5f55f59732',
Title: 'Right-sized clicks-and-mortar',
EmployeeName: 'Lance Fadel',
ProjectId: '0e8d4082-03be-40ce-938a-1898afb821a0',
ProjectTitle: 'B2B streamline modelsrgre',
PlannedHours: 490,
ActualHours: 411,
FunctionalArea: 'Financial',
Level1: '2.0...