I have a data set that contains various quantities for several years in a Spotfire table, however there are rows defined in a column as Budget or Actual, example table below (but in reality I have multiple different columns for Value):

I have a data table that looks like this:

I have been searching the API and the web for getting the data connection name programmatically within an IronPython script. You can find the data connection information, which includes the name, in Spotfire here:

PAGE FAB GROUP
0 12 1
1 1 1
2 5 2
3 45 2
4 78 2
5 63 3
6 5 3
7 1 4
8 0 4
9 1 5
10 5 5
11 48 5
12 6 6
13 3 6
14 8 7
15 498 7
16 46 8
17 23 8
18 5 8
19 8 9
20 5 9
21 7 10
22 4 10
23 1 11
24 15 11
25 45 11
26 84 12
27 61 12
28 2 13

I have an On-Demand table (For simplicity, let’s call this OD-Table1) that stores various data columns, however, I had to add columns from another table (Let’s call this Table2) to OD-Table1 because OD-Table1 is a separate database from Table2 and I cannot query them in the same query together. Table2 has values for “parts” of the OD-Table1. For a visual reference, here you go:

I’m currently building a reasonably complex Spotfire dashboard, that is intended to be deployed to users as a read only tool via our on-premise server. I would like to restrict users to view only mode. At the folder level I can set users to have read only permission to the library, but would like to prevent them from editing particular visualisations and accessing the data canvas.

May I know how to make the ranking functions in spotfire available? I do not know why, I tried searching it in web but there is no solution for it.

enter image description here

I have an activity related dataset and I’m trying to build a calculated column that will group any rows that can be considered as a batch of “Trouble Time” together. The concept of this column is to group the rows and find the total amount of lost time due to a failure. Each row will get a “Y” flag if it is “Trouble Time” and/or a “Failure”, otherwise it’s marked as “N”. The tricky part for me is the association/assignment to the failure and avoiding the “N” rows. Once I can figure out the calculated column, I can sum the total time over this group value and that shouldn’t be a problem. Make sure to note that there can be multiple types of the same Failure_Desc, so I need to keep each event separate. I’ve attached a picture of the sample dataset and my goal for my calculated column… please ask any questions needed for clarification. Really appreciate the help!