CODEWITHSUNDEEP
javascriptironpythonspotfire
Jon
Jon

Reputation: 161

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.

Sample Main and Details Visualization

Upvotes: 0

Views: 63

Answers (1)

Chelsea
Chelsea

Reputation: 511

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}')

Upvotes: 0

Related Questions