Stack Overflow
Stack Overflow

Questions tagged [periscope]

18 questions
2
votes
1 answer

How to alphabetically sort the columns in a table?

So my boss asked us to sort the columns alphabetically so the clients will have an easier time locating the column they want. The pictures below show what I mean by that. Currently, the columns are shown in an order like this: original…
Jianxiong Ji
  • 31
  • 2
1
vote
2 answers

How to limit by specific column?

I am attempting to limit by top 20 states by count(to_state). However, the limit command is limiting by the service column (shipment methods). I tried googling, and the only answer I can discover is an offset command, but I'm not sure how to…
Brandon
  • 117
  • 8
1
vote
1 answer

Searching for specific words in a text string - SQL

I wondered if someone might be able to help me. I know that I am doing something wrong and over-complicating this but i'm not sure what. I would like to pick out text from questions 205,227 and 278 when someone uses the words Autism, ASD, Aspergers…
jjdata
  • 33
  • 5
1
vote
1 answer

How can I make the denominator a constant for each of the numbers in the same row in SQL?

I am trying to create a table with the average amount of sales divided by a cohort of users that signed up for an account in a certain month, however, I can only figure out to divide by the number of people that made a purchase in that specific…
Lane Portman
  • 31
  • 3
0
votes
1 answer

Compare counts of two tables joined on week - SQL

I'm a newbie in SQL. I have two tables. I want to count the number of occurrences of one thing each week in the first, and of another thing each week in the second, and then compare them. I already have the codes for counting in two separate graphs…
ClaudeLag
  • 5
  • 2
0
votes
1 answer

The downloadablePlot Shiny Module breaks down my shiny app upon launching

I have the shiny app below and I would like to know how I can download a plot using the downloadablePlot Shiny Module. When I launch the app the whole app breaks down. library(shiny) library(periscope) ui <- fluidPage( plotOutput("plot"), …
firmo23
  • 7,490
  • 2
  • 38
  • 114
0
votes
1 answer

FFMPEG to periscope or twitter

In twitter studio to stream they specify RTMP URL rtmp://va.pscp.tv:80/x RTMPS URL rtmps://va.pscp.tv:443/x but when I do ffmpeg -re -i file.webm -c:v libx264 -preset ultrafast -vf "scale=-2:1080" -g 60 -pix_fmt yuv420p -c:a aac -b:a 128k -ac 2 -r…
Jintor
  • 607
  • 8
  • 32
0
votes
1 answer

Get percentage of values in redshift

If this question is asked or referenced somewhere else, please refer me to that place I am trying to get the percentage of how many New users of the total count of users and display that in a pie chart using Periscopedata(Sisense). select …
Tarek Al Beb
  • 1
  • 2
0
votes
1 answer

How to Limit Query Result to Organizations with 2 or More Accounts Associated with it

I have the following code which returns results for sub-organizations (of parent organizations) that do not have an address associated with them. However, this returns 2,000+ rows, many of which have 0 or 1 accounts associated with them. What I'd…
Jason Saven
  • 11
  • 2
0
votes
1 answer

How can I calculate a percentage of a preceding number in a SQL table?

I'm creating a retention cohort which shows the retention of my user base on our app, but I only know how to calculate the results in a count version, however, I really want the results to be percentages of the total cohort starting group (i.e. in…
Lane Portman
  • 31
  • 3
0
votes
3 answers

convert '19th October 2018' into date in Presto/SQL

I have a column of strings which have been extracted from email content. The strings are in the format:- Tuesday 12th March 2019 I can use split_part to drop the Tuesday (anything up to and including 'day' is cut) but that's a lot more difficult…
Barry Evans
  • 23
  • 1
  • 5
0
votes
1 answer

Why pivot table changed the float display to something differently?

I want to change the table display format so I used pivot_table but final result is completely changed I don't know why. Here is my code. import pandas as pd df = pd.DataFrame( [ ('2015/1/1', 73.23234, 'salgrp'), ('2015/2/1',…
Cloud Learner
  • 111
  • 1
  • 1
  • 8
0
votes
1 answer

Relation Card does not exist

The data I'm trying to query and summarize is daily transactional data for cardholders. I'm trying to aggregate first on a daily basis and then on a cumulative basis. I can successfully aggregate by day but when I add the following…
RedFociis
  • 1
  • 2
0
votes
1 answer

Is there an API to fetch Twitter Periscope live video statistics

I've a requirement to fetch Twitter Periscope live video stats, I looked for twitter APIs and found APIs to fetch tweet and media engagement, so can I use them to fetch live video stats as well, because Live video is also posted as a tweet, is my…
Akhil
  • 1,184
  • 1
  • 18
  • 42
0
votes
1 answer

API to check Periscope User is Online

I've scoured for any information regarding an Open API for Periscope. I have a twitter feed, that should only show if Periscope is Live (the said user will share the broadcast via Twitter). I can parse the word "IS LIVE" but then I'd have to parse…
andrew john mckinsey
  • 1
1
2