John

Hi Is there a way to include the 95th Percentile in Box Plot?

Hi David, currently, when using the Year and Week Function in spotfire, I noticed that this is default from Sunday to Saturday, can I have a formula wherein the Workweek starts from Monday to Sunday? Thanks!

Is there a way i can change the workweek from Monday to Sunday. Thanks!

Hi Gaia, I'm looking for adding the average. Thanks!

Hi! is anyone know how to do cumulative sum of an average? or any alternative solution below? for above data, I want to have a cumulative average of a column so i can have the the total hours on the last step. Thanks!

Hi! Regarding the Over Function, is it possible to do division on below two expressions to get the rate? 1st Expression/2nd Expression 1st Expression: SN(Sum([FGOUT]) / Count([FGOUT]),0) + SN(Sum([New_Early]),0) - SN(Sum([New_Backlog]),0) - SN(Sum([New_Commit Qty]),0) THEN sum([Value]) OVER (AllPrevious([Axis.Columns])) as [Delta] 2nd Expression: Sum(-[New_Commit Qty]) as [Commit]

HI Oliver, Yes it works!. Thanks!

Hi David, I already rename the [Delta] and I still facing the same error. I did try to remove the 4th expression and it's working. can we use two THEN statements in an expression?

This column suddenly turned red when applying a THEN on previous expression.

im having an error when i try ti copy your expression. can help?

Hi! Would it be possible to add multiple cumulative sum expressions? I want to get the delta of the following expression 1st Expression: SN(Sum([New_Backlog]) OVER (AllPrevious([Axis.Columns])),0) 2nd Expression: SN(Sum([New_Early]) OVER (AllPrevious([Axis.Columns])),0) 3rd Expression: Sum([New_Commit Qty]) Then Sum([Value]) OVER (AllPrevious([Axis.Columns])) as [Cumm Commit] 4th Expression: Sum([FGOUT])/Count([ExtractDate]) THEN Sum([Value]) OVER (AllPrevious([Axis.Columns])) as [Cumm Out] Delta Forumul 3rd Expression + 2nd Expression - 1st Expression - 4th Expression

Is ther a way how i can pass the value of listbox to a table to use as a dropdown value or listbox. thanks!

Hi @Ahmad Fattahi, not yet...

Any idea how to search specific strings inside a multiple text file and then convert this into a table?? Sample Output File name | String 1 | String 2 | String 3 | String 4 A.txt | A.1 | A.2 | A.3 | A.4 B.txt | B.1 | B.2 | B.3 | B.4

ok will do. thanks for notifying me..