Skip to main content

#Returns0 debatiendo

The following get request fails at Salesforce query connector, what is causing this;

GET request: http://host/customer?startDate=20221222133500

 

Salesforce query connector :

SELECT .......... FROM customer__c WHERE CreatedDate>=:startDate

 

 Parameter transformation in SF query connector:

{ "startDate" : attributes.queryParams.startDate as LocalDateTime {format: "yyyyMMddHHmmss"} as String {format: "yyyy-MM-dd'T'HH:mm"}

}

 

Error message from salesforce query:

CreatedDate>=2022-12-22T13:35:00.00

                 ^

ERROR at Row:1:Column:196

line 1:196 no viable alternative at character '<EOF>'

5 respuestas
  1. 11 ene 2023, 4:18

    I tried following expression;

     

    "startDateTime" : (attributes.queryParams.startDateTime as Date{format : "yyyy-MM-dd"}++"T00:00:00.000+0000") as String {format: "yyyy-MM-dd'T'HH:mm:ss.SSSZ"}

     

    Which generates correct startDateTime format and show up in debugger as follows:

    startDateTime=2023-01-05T00:00:00.000+0000

     

    which works fine and also doesn't show any error in salesforce parameter expression.

0/9000

Hi Team,

 

In my attached workbook I have three view in Dashboard.

 

But I have some challenges here listed

 

1) View 1 has Dimention has Hierachy, so user can expand and collpase from Region to State and City.

But If they do so Above text boxes that is created to group the measures are getting disaligned.

 

Example Group A Box should be on top of #Orders, #People and #Returns

Group B box on top of Discount and Profit

Group C Box on Top of Profit Ratio, Quantity, Sales

 

At first level this alignment correct, but if user expand to Region->State-> then it get disalligned.

 

Any workaround for this?

 

2) With expand and collapse below table measures also getting disaligned, example #Orders should be in one line for all the tables,

#People should be in one line for all the views etc. But everything getting disalinged when we expand or collpase. Any workaround for this?

1 respuesta
  1. 30 dic 2021, 23:03

    Hi Nilanjan,

     

    With Drill down on one view and with static dimension on the below view, it is not possible to have the alignment of the measures on the dashboard or of the text boxes.

     

    One work around I got is, on the first dashboard, we can have text boxes and measure names aligned on both the views. And, we can have an action on sheet 1 on select to pass it to the detailed view with drilled down values

     

    Regards,

0/9000

Hi, I need help with this ASAP, I've spent all day and looked stuff up but keep getting the same error.

I have a python script which works perfectly fine in python, and I've integrated TabPy etc. However, the same code is not working in Tableau and keeps outputting this same error. I've tried a few different things and have also gotten an error of "The result returned by the SCRIPT function is of unexpected type"

 

I've attached the script below (and the original python script as well is here):

 

import numpy as np  

def gs_calc(v,gr_ang,wind_v,wind_ang):

# v = flight airspeed

# gr_ang = ground track heading (0=N,90=E,180=S,270=W), ope but it's in radians

# wind_v = wind velocity

# wind_ang = wind angle (direction the wind is going, i.e. N->S is 180 deg) but also in radians

#RETURNS Ground Speed, in the same speed units as the other 2 velocities

    gr_unit = np.array([np.cos(gr_ang),np.sin(gr_ang)])

    wind = np.array([wind_v*np.cos(wind_ang),wind_v*np.sin(wind_ang)])

    dot_wind_gr = np.dot(wind,gr_unit)

    b = np.sqrt(sum((wind-dot_wind_gr*gr_unit)**2))

    gr_speed = np.sqrt(v**2 - b**2) + dot_wind_gr

    return gr_speed.tolist()

 

Help with TabPy - Tableau 4.2

 

Thank you!

4 respuestas
  1. 21 abr 2020, 21:28

    Under ..\Logs\ directory.

     

    By the way on the 2nd line of your script, shouldn't it be "(" vs "[" after np.array

     

    np.array( not np.array[

0/9000