I am trying to schedule refresh my data source in tableau online and I am getting a connection failure error. I talked with Tableau support to see if it's anything I did wrong in tableau but they said it's SQL Server issue. I can connect to SQL server using Windows Authentication and create reports and can publish them . when i publish them the server name is coming as localhost. So, I tried to do SQL Server Authentication and used username: sa and password and logged in Tableau Desktop and published the data source but the scheduling doesn't work and gives me an error of connection failure again. So i tried looking at the connections in tableau online. Tried localhost, username sa and when i press test connection it gives an error couldn't found the server.

Referencing this topic:  https://community.tableau.com/message/746162#746162

 1) I want to take it a step further and hide the relative dates (Start and End date Parameters).
OR
2) Can I populate the start and end date parameters based on my selection?
 
For example:
Past Month would display 6/1/18 in the start date and 6/30/18 in the end date.

YTD would display 1/1/18 in the start date and 7/12/18 in the end date, etc

 

If that is not possible then I just want to be able to hide the start and end date parameters unless I choose CUSTOM.

 

--------------------------------------------------------------------------------------------

Here is the case statement for the drop-down Date Filter:

CASE [Select Range]

WHEN "Most Recent Date" THEN

    //Sunday

    IIF (DATEPART('weekday',TODAY()) = 1,(IF DATEADD('day',-3,TODAY()) = [Date] THEN "Keep" Else "Drop" END),

    //Monday

    IIF (DATEPART('weekday',TODAY()) = 2,(IF DATEADD('day',-4,TODAY()) = [Date] THEN "Keep" Else "Drop" END),

    //All other days

    IIF (DATEADD('day',-2,TODAY()) = [Date],"Keep","Drop")))

WHEN "Past Week" THEN

    IF DATEPART('weekday',TODAY()) = 2 THEN

    (IF (DATEPART('week',[Date]) = DATEPART('week',TODAY())-1 OR (DATEPART('week',TODAY()) <= 1 AND DATEPART('week',[Date]) = 1)) AND DATEPART('weekday',[Date]) < 6 AND DATEPART('weekday',[Date]) > 1 AND [Date] > DATEADD('day',-365,TODAY()) THEN "Keep" END)

    ELSE

    IF …

I'm trying to create a custom Google Analytics custom report that shows the following by date range: Organic Search, Direct Traffic, Referral, Social, Email, PPC and also somewhere in the report show the PPC spend.  

Let me know if this is possible and how to do it.  I've not used custom reports much.

Cognos 10, Oracle database. Situation is that a list inside a table is repeating itself and I'm looking for a way to not have it repeated. Is there an option in the properties page that might need enable or disable to resolve this issue. Please see attached image.

Thanks
Capture.JPG

Hello All,

Hope someone clarify the error I have in my STIDF data plot.
I'm reading through related questions but no solution fixed my error.

I'm working on STIDF  and I want to use stplot and spplot but it seems spplot is not suitable for STIDF.

When I use stplot I always get this error:

    Error in `levels<-`(`*tmp*`, value = if (nl == nL) as.character(labels) else paste0(labels,  :
      factor level [2] is duplicated

Here's how my data in STIDR data type looks:

           Lat         Long       sp.ID       time                                 endTime              TimeIndex     Speed    Station_ID    
    41.71268  -87.64341    1      2017-07-01 00:00:00   2017-07-01 18:00:00       1                    86           2
    41.47268  -87.35281    2      2017-07-01 00:00:00   2017-07-01 18:00:00       1                    35           5
    41.71268  -87.64341    3      2017-07-01 01:00:00   2017-07-01 18:01:00       2                    43           2
    41.47268  -87.35281    4      2017-07-01 01:00:00   2017-07-01 18:01:00       2                    55           5

I think it's related to my ID variable but I have duplicated station ID because I have hourly reading for each location , so ID will be repeated in my dataset.

I tried this code but I still have the error message,

 STIDF_jour$Station_ID <- factor(STIDF_jour $Station_ID, levels = rev(unique(STIDF_jour $Station_ID)), ordered=TRUE)

Hi

I have below scenario and need help to address this issues. What would be your approach to solve this problem in bullet points or brief summary like  what is your assumptions,explain your analysis approach and chosen analytics techniques, expected output results, what recommendations do you suggest,do you see limitations

1. How would you assess the impact of weather on consumer spend last winter?

2. How would you determine if a specific block in your neighborhood is suitable for a new grocery store?

3. Bank XYZ has created a new credit card product, how would you determine the targeting strategy?

4. Bank XYZ  has observed declining credit card sales volumes in their core markets. How would diagnose the cause and what potential remediation’s may be put in place (if any)

5.  Credit Card company recently announced a new partnership with a key tech company. How would you quantify the per customer incremental value of this partnership?

Thanks

Can anyone tell what is the difference between data analytics and data science?

My Google Analytics  Site Content |  Landing Pages report shows a row with (not set).  See attached file.  Does anyone know what is generating these?

Thank you.
not_set.jpg

Normally I've seen MOS scores on a 1 to 5 point scale. But in Skype for Business Call Analytics they're expressed a decimal. e.g.

Average network degradation 0.009717 MOS

What are they saying? Is that a 4.93 MOS score?
ScrnGrab2671-171018-17.21.jpg

I would like to have better analytics of call quality over time. Is there any way to have a server at each site and run a nailed up simulated call between the two and gather metrics like loss, jitter, MOS, latency etc etc? Anything from MS? Other?

Hi,

I have built a small wordpress widget that floats in the bottom right hand corner of my client's website(s), so that their users can click it to make a payment to them... which simply redirects the user to my payment platform / website where my customer has an account.

FLOW - widget sits on clientwebsite.com and when they click it, the customer is brought to mysplink.com/abc (their payment profile on splink)

QUESTION
I need to be able to track how many users land on mysplink.com from a widget that sits on another site.

I was thinking of using something like mysplink.com/abc/ref=widget-abc and then i can view that in Google Analytics?

01 - would this approach be the best way to do this?

02 - any other advice on approaches would be greatly appreciated

Thank you in advance for your help.

HI All,

I am looking for Tableau interview questions and certification material. Looking for some good learning resources and get certified as earliest. Please share interview material and certification stuff. Greatly appreciated

Thanks

Hello All Experts,
I am a student enthusiast in learning "Data Analytics" , which is the best platform to learn for FREE?
I want to Learn 'Data Science (Statistics)' & 'SAS/R' from scratch?
Any videos? Any websites? Any Blogs?

Thanks,

Regards,
Satish Kumar G N