Hi Carl, Why this functionality is not working for every Table in Salesforce Einstein Analytics? Is there any limitation?
@user-wm1ut7sg6f Жыл бұрын
Thanks Carl. Your old video was really helpful also. The one thing that I don't see is the ability to see generate row level subtotals, only a grand total. How would that be accomplished? When I use the rollup function I can see subtotals but only on the column total, not the pivot level columns. Can you advise on how to add this? Thank you. I'm grateful for the knowledge you have given us over the years.
@mohittyagi91412 жыл бұрын
Hi Carl, I hope you are doing great. I am looking for a solution in Einstein analytics id, name, group_id, group_name due_date, volume, Premium these are the fields which i have in my receipe. I want to add additional fields using due_date because in every cell of due_date has the values like 1/1/2020,1/2/2020,.....1/12/2020,1/1/2021.....1/12/2021,1/1/2022....using id, due_date(monthly basis) want to summarise the table. The output should look like : id, name, group_id, group_name due_date, volume, Premium, jan'21(bill), Jan'21(received),Feb'21(bill),Feb'21(received)......Dec'21(bill),Dec'21(received),Jan'22(Bill),Jan'22(received) note: Jan'21 bill will be sum(premium) of dec'20, Jan'21 received will be sum(premium) of jan'21, Feb'21 bill will be sum(premium) of Jan'21 received, Feb'21 received will be Feb'21 received......Like that sum(premium) will be calculate based on each id. Output will be like a table. Please Carl, help me out in this query,I am your subscriber. Thanks!
@carlbrundage19652 жыл бұрын
There's a new, even easier way to add column and row totals with Pivot tables in the Summer 22 release. See the updated video - kzfaq.info/get/bejne/qNldq8130JfHj4k.html
@raynagiron33872 жыл бұрын
Hi, how do you enable authentication in last pass so you can use it for salesforce MFA?
@carlbrundage19652 жыл бұрын
First, you have to be on a business account. If you are using LsatPass personal, it does not show up. You also have to setup MFA with LastPass before you can use TOTP. There is also a LastPass policy "Don't show TOTP in vault" that your Business admin might have enabled. This would prevent access as well.
@pranavsharma30123 жыл бұрын
Hi Carl.. Nice video...But in my case when using sub totals then grouping of fields is not proper. Please suggest what should be done
@xie86884 жыл бұрын
Would be nice if you can show the before/after table as an example
@pedroprada14 жыл бұрын
THanks Carl... great video... first time I see a Pivot table use case in EA
@user-wm1ut7sg6f4 жыл бұрын
Great video Carl. I employed this technique on my dashboard but am having problems getting the Total to sort to the bottom. I tried renaming the field value to zTOTAL in the SAQL code then hoped to relabel in the XMD but the new value doesn't show up in the members list of values. How else could this be accomplished?
@alexandermorenocamacho31754 жыл бұрын
Hello Carl, how can I change the color to the TOTAL text
@carlbrundage19654 жыл бұрын
Check out the Spring 20 release notes. There is now the ability to turn on/off grand total and sub totals. If you pick a style for the table, it will color the headers. releasenotes.docs.salesforce.com/en-us/spring20/release-notes/rn_bi_platform_totals.htm
@alexandermorenocamacho31754 жыл бұрын
@@carlbrundage1965 Thanks Carl, if I already checked them but it is not possible to put sub totals to the pivot tables
@user-wm1ut7sg6f4 жыл бұрын
@@alexandermorenocamacho3175 I have the same problem since it's from a pivot table, the option to add totals and subtotals isn';t available.
@williamcollier36805 жыл бұрын
Very interesting but as asked below, how to get this Please? Many thanks.
@carlbrundage19655 жыл бұрын
The SAQL would differ based on your specific dataset and fields. You can use the approach from the video to apply to your specific case.
@muskieAA5 жыл бұрын
Thanks Carl! Awesome video
@marktossell84615 жыл бұрын
Thanks, Carl.
@LetsPlaySalesforce6 жыл бұрын
Nice UI hack making the link widgets look like toggles. What really brings this together is that there's no noticeable loading effect when switching pages.