6 respostas
@Ryohei Moriyama interesting exercise.
The only way to this is to select ⌗ID, ⌗discount, ⌗number of records and right click and "Hide".
This is not most elegant way - it is the only way in this example.
thanks,
Adrian
#Id0 discutindo
- Atividade recente
- Data de criação
- Recomendado
- Todas as perguntas
- Perguntas com uma resposta aceita
- Perguntas não respondidas
- Perguntas sem resposta aceita
hi
attached is a table i created
the second measure is created by using this formula : {FIXED [CODE] : AVG([LowestPricePerCarat_Calc])}
now i want to create a number i can use in a different place, that will show me the average of this column in the table -
in my case - the average of 2229, 2126,2229,2229. the problem is when i am doing an average it shows me only the average of 2229, 2126 (since there are only 2 different {codes] ).
how can i get the average of all of the numbers ?
thank you!
10 respostas
@Oren Yannai you'll just need to include your [#ID] field in the average calculation
See attached for reference 😊
I hope this helps!
Kelsie
below parameters given:
Name : Delete
Event: Internal
Requires Editable : True
Action type: Row button
Event payload: {"Action":"Delete","sObjectID","#.Id#"}
Icon: utility:delete
5 respostas
This worked for me, and I'm posting it so next time I search how to do it I will find it again
Name: Delete
Event: Internal
Required Deletable: True
Event Payload: {"Action":"Delete","sObjectID":"#Id#"}
Icon: utility:delete
Hi,
I would like to know if the tabcmd publish operation can also have errors.
I created a script that appends approximately 10GB of data.
I've been using this script for about 7 months and I've never experienced any problems.
I checked the execution process of the script with my eyes and even checked that the command window was closed, but the data was not applied on the tableau server.
Can this happen?
The script used is as follows and the problem occurs only tabcmd publish's line.
chcp 65001
tabcmd login -s ⌗address -u ⌗ID -p ⌗PASSWORD
tabcmd get ...
tabcmd publish ⌗local_path -n ⌗NAME -r ⌗PROJECT_NM --append
echo 'completed'
Thank you.
4 respostas
Hello @Ciara Brennan
I solved this problem by dividing the file into two.
And recently I had other problems with tabcmd publish. So I have 2 questions about tabcmd append.
At first, I would like to know the general case where tabcmd append fails.(ex. data shapes or column names are different each other)
Secondly, I wonder if it is possible to fail to append a file that is a big size of data.
I also have some uncomfortable cases when I execute tabcmd publish through the batch file.
The first case is that the modified time of the data source had been changed too late sometimes although the tabcmd publish batch file is completed. Especially this happens when I append over 10GB of data. I guess it took about 2 to 5 minutes.
The second case is that I everyday append 18GB of data using a batch file(about publish(append) of tabcmd) with the window scheduler. Sometimes, however, it has a fail once about every three months.
Salesforce strange behavior:-
I have embedded my LWC comp under Standard record detail page which URL is something like that "https://xxxxxx-xxx-ed.lightning.force.com/lightning/r/Account/0015i00000QbzRjAAJ/view"
but when I am trying to call this record page from somewhere else and pass an extra parameter Id into it("https://xxxxxx-xxx-ed.lightning.force.com/lightning/r/Account/0015i00000QbzRjAAJ/view#id=0Q0770000004o8oCAA" Then this page get refresh every time whenever I switch between tabs(under Sales Console App).
which is very strange!
@Tokopedia Salesforce Developer @Customer Success Trailblazer Community Team@* Salesforce Platform *@* Trailhead Official *@Trailblazer Community Cove
Hello,
I have a database count of products per client email( id ) table.
There are three types of clients. I know the exact clients for the first category and second category - based on the clients ids/emails. The third category should be total of id-s minus the ones in the first category and the second one. What is the best way to create these 3 categories in a table?
Group, sets, calculated field....?
Thank you so much!
3 respostas
As a calculated field ? I would do it this way ...
IF <condition goes here> THEN 'Cat A'
ELSEIF <condition goes here> THEN 'Cat B'
ELSE 'Cat C'
END
The condition can be as long and complex as you need, you can use AND and OR as required, ultimately if the Cat A condition isn't a match, then try Cat B condition and when that's not a match then it must be Cat C
Hi, I am using Create table syntax to create a global temp table and then use insert to insert 5000 rows into the temp table. However, only 400 to 900 rows get inserted. Is this the limitation in table or am I missing anything ? Below is the create and insert code use:
IF OBJECT_ID('tempdb..##id') IS NOT NULL
BEGIN
DROP TABLE ##id
END
CREATE TABLE ##id(Id VARCHAR(50))
Insert INTO ##id(Id) VALUES('14452')
Insert INTO ##id(Id) VALUES('33666')
Many thanks in advance for the help!
Amy
3 respostas
Yes I think so, sorry @Amy Amy. Depending on your version, do you have the option to join onto a CSV file with those ids as well potentially? E.g. in the example below I've added and then joined a separate Excel sheet on the Superstore sample data set (in this case for some data densification hence the join on 1=1, you would join on Id presumably).
Please do upvote anything that's been helpful and, if appropriate, mark an answer as "best" to close off the thread and help people searching in the future.
Ta, Steve.
Ta, Steve.
I have one ID for a whole process: #ID 00001 Someone ask for this item
#ID 00001 Someone get the item
#ID 00001 Someone deliver the item
When the same id apear for the third time, it means the whole process has been completed.
When someone ask for the item, this process code change 0 to 1
When someone get the item, this process code change 1 to 2
When someone deliver the item, change 2 - 0
So, i need to know how many items was delivered under 20 minutes, 1 hour, 10 hour and over 10 hours.
If possible to build a sheet that show which item of each time.
Do someone know how can i do this.
5 respostas
Help me understand how this ID would work. There are multiple instances where Prec=5 and Status=2 (and the same with 3/5) so which records are the actual start and end?
I want to realize tableau viz animation. As a simple demo, I switch between two viz every 30 seconds. I'd like that the animation be stopped by a click action on no matter where in the page and the animation restarts if no click during 10 seconds.
But I came across with the following problems which I would appreciate your help:
- Does event Listener work as well in story visualization? Embedding this https://public.tableau.com/views/EPLInjuries/InjuryCrisis?:embed=y&:loadOrderID=0&:display_count=yes , I’ve added an Marks_Selection event Listener. But I got no reaction. But if I use https://public.tableau.com/views/OddsofGoingProinSports/OddsofGoingProinSports?:embed=y&:loadOrderID=0&:display_count=ye… which is only a dashboard not a story, the event listener works! Maybe stories are dealt differently, or there may be some options we can set to make a viz interactive to selection?
- Does tableau API has a click event handler but not a mark selection handler? I want an event listener to handler click action on a tableau viz no matter on a mark or not.
- I suppose that Tableau doesn't provide a click event handler. Using jquery, I've added a $('#id').click() to my viz. However, it seems that the tableau viz container doesn't react to any click action. I wonder if a viz is treated differently as a special element in html or there maybe some options to set to make a viz interactive by api?
All help appreciated!
Best regards,
Benjamin
2 respostas
Hey Benjamin,
Could you share some of the work you've already done so other users can better assist?