Jump to content

John

Members
  • Posts

    19
  • Joined

  • Last visited

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

John's Achievements

Apprentice

Apprentice (3/14)

  • Collaborator Rare
  • One Month Later
  • Dedicated Rare
  • First Post Rare
  • Conversation Starter Rare

Recent Badges

0

Reputation

  1. 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!
  2. Is there a way i can change the workweek from Monday to Sunday. Thanks!
  3. Hi Gaia, I'm looking for adding the average. Thanks!
  4. 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!
  5. 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]
  6. HI Oliver, Yes it works!. Thanks!
  7. 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?
  8. This column suddenly turned red when applying a THEN on previous expression.
  9. im having an error when i try ti copy your expression. can help?
  10. 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
  11. Is ther a way how i can pass the value of listbox to a table to use as a dropdown value or listbox. thanks!
  12. John

    CoPilot in Spotfire

    Hi @Ahmad Fattahi, not yet...
  13. 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
  14. Any idea how to search specific strings inside a multiple text file and then convert this into a table?? 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
×
×
  • Create New...