Marked Items in Horizontal Chart matching with created details visualization
I have a horizontal bar contains top 25 defect rate and also created a details visualization using cross table. When i marked the top 1 the details like model and qty populate and shown in cross table. My requirements is to count/sum all records with marked and unmarked and use as multiplier to the qty to get the d rate the cross table.
I try this approached dynamically Sum(case when [XXX]="XXX" then 1 end) OVER (All([Axis.Rows])) as [Overall Total] but the result is the total qty that are marked are the one displayed or captured. Is there any idea on how to do this using over function or other approached. Thank you in advance.
javascript ironpython spotfire
asked Nov 28 '18 at 6:29
JovJov
325
add a comment |
I have a horizontal bar contains top 25 defect rate and also created a details visualization using cross table. When i marked the top 1 the details like model and qty populate and shown in cross table. My requirements is to count/sum all records with marked and unmarked and use as multiplier to the qty to get the d rate the cross table.
I try this approached dynamically Sum(case when [XXX]="XXX" then 1 end) OVER (All([Axis.Rows])) as [Overall Total] but the result is the total qty that are marked are the one displayed or captured. Is there any idea on how to do this using over function or other approached. Thank you in advance.
javascript ironpython spotfire
asked Nov 28 '18 at 6:29
JovJov
325
If I understand correctly, the problem is that the Details Visualization doesn't actually contain all of the data, just what's marked. The Over Function can only process what's inside the actual visualization, not the entire data table. Remove the filter by rows marked, and adjust from there. If that's not the issue, I think you need to provide more information -- please provide a sample of your columns/data and what you'd like to see, if everything's working correctly.
– Chelsea
Nov 28 '18 at 17:39
Yes Chelsea, it contains only the marked data of details visualization. i got only the qty which is Ok but i need to multiply the qty of detail visualization to the overall total to get the rate %. Is there any alternative using scripting?
– Jov
Nov 29 '18 at 3:36
Please find above the sample screen shot. select the top 1 in main visualization and populate the data to details visualization. it shows only the qty. Need the overall count which i would like to multiply to qty to get the rate% per category or it depend on values the i choose from the dropdown.
– Jov
Nov 29 '18 at 5:43
Thanks Chelsea. I got it. my concern is how can i passed the selected item (description)
– Jov
Nov 29 '18 at 6:45
add a comment |
I have a horizontal bar contains top 25 defect rate and also created a details visualization using cross table. When i marked the top 1 the details like model and qty populate and shown in cross table. My requirements is to count/sum all records with marked and unmarked and use as multiplier to the qty to get the d rate the cross table.
I try this approached dynamically Sum(case when [XXX]="XXX" then 1 end) OVER (All([Axis.Rows])) as [Overall Total] but the result is the total qty that are marked are the one displayed or captured. Is there any idea on how to do this using over function or other approached. Thank you in advance.
javascript ironpython spotfire
asked Nov 28 '18 at 6:29
JovJov
325
I have a horizontal bar contains top 25 defect rate and also created a details visualization using cross table. When i marked the top 1 the details like model and qty populate and shown in cross table. My requirements is to count/sum all records with marked and unmarked and use as multiplier to the qty to get the d rate the cross table.
I try this approached dynamically Sum(case when [XXX]="XXX" then 1 end) OVER (All([Axis.Rows])) as [Overall Total] but the result is the total qty that are marked are the one displayed or captured. Is there any idea on how to do this using over function or other approached. Thank you in advance.
javascript ironpython spotfire
javascript ironpython spotfire
asked Nov 28 '18 at 6:29
JovJov
325
asked Nov 28 '18 at 6:29
JovJov
325
edited Nov 29 '18 at 3:40
Jov
asked Nov 28 '18 at 6:29
JovJov
325
asked Nov 28 '18 at 6:29
JovJov
325
asked Nov 28 '18 at 6:29
JovJov
325
325
If I understand correctly, the problem is that the Details Visualization doesn't actually contain all of the data, just what's marked. The Over Function can only process what's inside the actual visualization, not the entire data table. Remove the filter by rows marked, and adjust from there. If that's not the issue, I think you need to provide more information -- please provide a sample of your columns/data and what you'd like to see, if everything's working correctly.
– Chelsea
Nov 28 '18 at 17:39
Yes Chelsea, it contains only the marked data of details visualization. i got only the qty which is Ok but i need to multiply the qty of detail visualization to the overall total to get the rate %. Is there any alternative using scripting?
– Jov
Nov 29 '18 at 3:36
Please find above the sample screen shot. select the top 1 in main visualization and populate the data to details visualization. it shows only the qty. Need the overall count which i would like to multiply to qty to get the rate% per category or it depend on values the i choose from the dropdown.
– Jov
Nov 29 '18 at 5:43
Thanks Chelsea. I got it. my concern is how can i passed the selected item (description)
– Jov
Nov 29 '18 at 6:45
add a comment |
If I understand correctly, the problem is that the Details Visualization doesn't actually contain all of the data, just what's marked. The Over Function can only process what's inside the actual visualization, not the entire data table. Remove the filter by rows marked, and adjust from there. If that's not the issue, I think you need to provide more information -- please provide a sample of your columns/data and what you'd like to see, if everything's working correctly.
– Chelsea
Nov 28 '18 at 17:39
Yes Chelsea, it contains only the marked data of details visualization. i got only the qty which is Ok but i need to multiply the qty of detail visualization to the overall total to get the rate %. Is there any alternative using scripting?
– Jov
Nov 29 '18 at 3:36
Please find above the sample screen shot. select the top 1 in main visualization and populate the data to details visualization. it shows only the qty. Need the overall count which i would like to multiply to qty to get the rate% per category or it depend on values the i choose from the dropdown.
– Jov
Nov 29 '18 at 5:43
Thanks Chelsea. I got it. my concern is how can i passed the selected item (description)
– Jov
Nov 29 '18 at 6:45
If I understand correctly, the problem is that the Details Visualization doesn't actually contain all of the data, just what's marked. The Over Function can only process what's inside the actual visualization, not the entire data table. Remove the filter by rows marked, and adjust from there. If that's not the issue, I think you need to provide more information -- please provide a sample of your columns/data and what you'd like to see, if everything's working correctly.
– Chelsea
Nov 28 '18 at 17:39
If I understand correctly, the problem is that the Details Visualization doesn't actually contain all of the data, just what's marked. The Over Function can only process what's inside the actual visualization, not the entire data table. Remove the filter by rows marked, and adjust from there. If that's not the issue, I think you need to provide more information -- please provide a sample of your columns/data and what you'd like to see, if everything's working correctly.
– Chelsea
Nov 28 '18 at 17:39
Yes Chelsea, it contains only the marked data of details visualization. i got only the qty which is Ok but i need to multiply the qty of detail visualization to the overall total to get the rate %. Is there any alternative using scripting?
– Jov
Nov 29 '18 at 3:36
Yes Chelsea, it contains only the marked data of details visualization. i got only the qty which is Ok but i need to multiply the qty of detail visualization to the overall total to get the rate %. Is there any alternative using scripting?
– Jov
Nov 29 '18 at 3:36
Please find above the sample screen shot. select the top 1 in main visualization and populate the data to details visualization. it shows only the qty. Need the overall count which i would like to multiply to qty to get the rate% per category or it depend on values the i choose from the dropdown.
– Jov
Nov 29 '18 at 5:43
Please find above the sample screen shot. select the top 1 in main visualization and populate the data to details visualization. it shows only the qty. Need the overall count which i would like to multiply to qty to get the rate% per category or it depend on values the i choose from the dropdown.
– Jov
Nov 29 '18 at 5:43
Thanks Chelsea. I got it. my concern is how can i passed the selected item (description)
– Jov
Nov 29 '18 at 6:45
Thanks Chelsea. I got it. my concern is how can i passed the selected item (description)
– Jov
Nov 29 '18 at 6:45
add a comment |
1 Answer
1
active
oldest
votes
If what you're looking for is to grab the description of your marked data when you press a button, the general IronPython Script is here:
rowIndexSet=Document.ActiveMarkingSelectionReference.GetSelection(Document.Data.Tables["DataTableName"]).AsIndexSet()
if rowIndexSet.IsEmpty != True:
SelectedDesc = Document.Data.Tables["DataTableName"].Columns["Description"].RowValues.GetFormattedValue(rowIndexSet.First)
Document.Properties["PropertyName"] = SelectedDesc
Please note that this will only grab the first marked value, which sounds sufficient for your use case.
You can then throw this Document Property in your over custom expression as per usual
([description] ='${PropertyName}')
answered Nov 29 '18 at 15:40
ChelseaChelsea
37638
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53513421%2fmarked-items-in-horizontal-chart-matching-with-created-details-visualization%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
If what you're looking for is to grab the description of your marked data when you press a button, the general IronPython Script is here:
rowIndexSet=Document.ActiveMarkingSelectionReference.GetSelection(Document.Data.Tables["DataTableName"]).AsIndexSet()
if rowIndexSet.IsEmpty != True:
SelectedDesc = Document.Data.Tables["DataTableName"].Columns["Description"].RowValues.GetFormattedValue(rowIndexSet.First)
Document.Properties["PropertyName"] = SelectedDesc
Please note that this will only grab the first marked value, which sounds sufficient for your use case.
You can then throw this Document Property in your over custom expression as per usual
([description] ='${PropertyName}')
answered Nov 29 '18 at 15:40
ChelseaChelsea
37638
add a comment |
If what you're looking for is to grab the description of your marked data when you press a button, the general IronPython Script is here:
rowIndexSet=Document.ActiveMarkingSelectionReference.GetSelection(Document.Data.Tables["DataTableName"]).AsIndexSet()
if rowIndexSet.IsEmpty != True:
SelectedDesc = Document.Data.Tables["DataTableName"].Columns["Description"].RowValues.GetFormattedValue(rowIndexSet.First)
Document.Properties["PropertyName"] = SelectedDesc
Please note that this will only grab the first marked value, which sounds sufficient for your use case.
You can then throw this Document Property in your over custom expression as per usual
([description] ='${PropertyName}')
answered Nov 29 '18 at 15:40
ChelseaChelsea
37638
add a comment |
If what you're looking for is to grab the description of your marked data when you press a button, the general IronPython Script is here:
rowIndexSet=Document.ActiveMarkingSelectionReference.GetSelection(Document.Data.Tables["DataTableName"]).AsIndexSet()
if rowIndexSet.IsEmpty != True:
SelectedDesc = Document.Data.Tables["DataTableName"].Columns["Description"].RowValues.GetFormattedValue(rowIndexSet.First)
Document.Properties["PropertyName"] = SelectedDesc
Please note that this will only grab the first marked value, which sounds sufficient for your use case.
You can then throw this Document Property in your over custom expression as per usual
([description] ='${PropertyName}')
answered Nov 29 '18 at 15:40
ChelseaChelsea
37638
If what you're looking for is to grab the description of your marked data when you press a button, the general IronPython Script is here:
rowIndexSet=Document.ActiveMarkingSelectionReference.GetSelection(Document.Data.Tables["DataTableName"]).AsIndexSet()
if rowIndexSet.IsEmpty != True:
SelectedDesc = Document.Data.Tables["DataTableName"].Columns["Description"].RowValues.GetFormattedValue(rowIndexSet.First)
Document.Properties["PropertyName"] = SelectedDesc
Please note that this will only grab the first marked value, which sounds sufficient for your use case.
You can then throw this Document Property in your over custom expression as per usual
([description] ='${PropertyName}')
answered Nov 29 '18 at 15:40
ChelseaChelsea
37638
answered Nov 29 '18 at 15:40
ChelseaChelsea
37638
answered Nov 29 '18 at 15:40
ChelseaChelsea
37638
answered Nov 29 '18 at 15:40
ChelseaChelsea
37638
37638
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53513421%2fmarked-items-in-horizontal-chart-matching-with-created-details-visualization%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
If I understand correctly, the problem is that the Details Visualization doesn't actually contain all of the data, just what's marked. The Over Function can only process what's inside the actual visualization, not the entire data table. Remove the filter by rows marked, and adjust from there. If that's not the issue, I think you need to provide more information -- please provide a sample of your columns/data and what you'd like to see, if everything's working correctly.
– Chelsea
Nov 28 '18 at 17:39
Yes Chelsea, it contains only the marked data of details visualization. i got only the qty which is Ok but i need to multiply the qty of detail visualization to the overall total to get the rate %. Is there any alternative using scripting?
– Jov
Nov 29 '18 at 3:36
Please find above the sample screen shot. select the top 1 in main visualization and populate the data to details visualization. it shows only the qty. Need the overall count which i would like to multiply to qty to get the rate% per category or it depend on values the i choose from the dropdown.
– Jov
Nov 29 '18 at 5:43
Thanks Chelsea. I got it. my concern is how can i passed the selected item (description)
– Jov
Nov 29 '18 at 6:45