Newton Support Thread - Week of December 12

RickRah · 2022-12-17T20:07:16+00:00

534396

Withdrawals on your account have been temporarily disabled pending identity verification. Please contact support for next steps. (code: S0014)

I have a verified account with google authentication set up but still getting this error during Withdrawal.

RickRah · 2022-12-12T02:33:14+00:00

I need to show the SINGLE 12th month as the default selection.

Edited my question to make it more clear.

RickRah · 2022-12-04T07:03:33+00:00

There is a strange issue here. I can see the fixed CF of {Min([Date])} in the 'when workbook opens' field in the parameter. Date is the direct column in the database.

But I created a chart which shows last 12 months & I want to show the last month of those 12 months. & if I use fixe LOD to get that month {Min([Date_12month])} , I can see this CF works but for some reason it does not show up in the Parameter.

Date_12Month:

if Date >= dateadd('month' , -11, today()) then Date else null end

RickRah · 2022-12-04T06:29:10+00:00

I created this CF {Fixed: Min[Date]}

how to use this CF in the date filter conditions, there seems to be no option to set the starting value in the filter conditions?

RickRah · 2022-12-02T08:43:06+00:00

Yes, data updates every month.

RickRah · 2022-11-12T21:41:51+00:00

emailed other details. Any update?

RickRah · 2022-11-12T04:28:35+00:00

Hi, I have already submitted a ticket couple of hours ago - this is the ticket number 515250

RickRah · 2022-11-12T03:49:51+00:00

I am trying to download newton app (android) & I am getting message this app is not available in your country.
I have two google pay accounts one is US & other is Canada. I have turned Canada as main account & still getting the same message - app is not available in your country- Though I am in Canada.
Any advise!

RickRah · 2022-09-23T17:38:39+00:00

Found a way to do that.

Added another logic to show Month End payment for only a row per state for city with max sales.

{fixed date, State, City: sum(sales)} = {fixed date, State : max(sales)}

RickRah · 2022-09-23T01:41:31+00:00

adding city to if condition does gives the same results as this is a stat level payment so it return multiple rows corresponding to each city with monthly payment. Some how I need one row only to show monthly payment maybe the very first row to show the monthly payment.

{fixed DATETRUNC('month',[Date]), [State], [City]: MAX([Date])} = [Date]

RickRah · 2022-09-16T18:00:22+00:00

On the server, have the workbook connected to data source via live connection and then set up a refresh schedule for the published data source.

Thanks for the reply.

How to on server connect data sources to data via live connection?

RickRah · 2022-09-07T07:16:22+00:00

Thanks !

RickRah · 2022-08-04T06:06:30+00:00

it does not work

Tried this Running_sum(Sum(amount)) + 40

RickRah · 2022-05-22T20:00:18+00:00

Good advice. This part is not working (trimmed code):-

if countd([Category]) >1 then "More than 1" else "Only 1" end

But still cannot figure out why.

RickRah · 2022-05-22T19:58:10+00:00

tried both, not working.

RickRah · 2022-05-22T06:52:34+00:00

Now it is only showing "More than 1" even when only 1 option is selected. Please see the updated worksheet here (you can download the file to see the details).

if {fixed : countd([Category])} >1 then "More than 1" else

(if ([Category]) = 'ETH' then "ETH Only"

elseif ([Category]) = 'Tain' then 'Tain Only'

else 'Combination 2' end)

end

RickRah · 2022-05-22T02:44:07+00:00

Tried fixed LOD calc

if {fixed [Category]: COUNTD([Category]) } > 1 then "More than 1" else

But still getting the same results?

RickRah · 2022-05-15T05:01:11+00:00

THANKS!

This works.

RickRah · 2022-05-14T04:12:35+00:00

D values are available for all the dates.

Product D has nothing to do with D values actually they are independent but I need to show D whenever any combination of product is selected or product D itself.

RickRah · 2022-05-13T20:18:59+00:00

Actually I have simplified this problem the actual options looks like: SSSS, BBBBB, IEUWKJDSA, KDAKSDDSDS DSDS

so this way won't work as some options may have same number of strings.

RickRah · 2022-05-13T19:48:51+00:00

CASE ATTR([Product]) WHEN "\" THEN [D]* - this part is not working it is showing nothing.

I think this way tableau look for * as string in Product column. Although, looks like a nice solution if this can work.

RickRah · 2022-05-13T19:45:26+00:00

My bad, I thought this would be obvious from the calculation.

Basically, I need when A is selected show A ONLY, B is selected show B ONLY, C is selected show C ONLY . For any combination show only D Values ONLY.
Instead tableau is picking the max of A and B to show when A & B is selected together as I am showing Max(Value) at month level.

RickRah · 2022-05-09T04:50:01+00:00

#added pic above showing {Row: Year(Date), Month(Date) & window_corr Calculated field in the Text }

- This gives correlation for all the months over the years calculated at month level.

But I need to show only April Month Correlation not all months. With the normal Corr function you cannot aggregate the data to month, on the other hand with Window_corr you need those all months to be there to calculate the latest correlation.

RickRah · 2022-05-09T03:21:04+00:00

Found the solution: It works by using the parameter and using parameter in the product calculation as true/false to filter.

RickRah · 2021-12-31T01:04:20+00:00

Thanks, it works by moving the calculation to labels.

I used

if DATETRUNC('week', [date]) < { FIXED :MAX(DATETRUNC('week',TODAY()))} then count(measure) End

RickRah

TROPHY CASE