×Sorry to interruptThis page has an error. You might just need to refresh it.
Unable to find an action for 325;a: {"id":"325;a","state":"SUCCESS","returnValue":{"componentDef":{"descriptor":"layout://rl-User-VIEW-FULL----force_highlights-_1-0-674b574567657471726c42666756465a66576b5766673d3d.c"},"original":"markup://force:recordLayout","creationPath":"/*[0]","attributes":{"values":{"mode":"VIEW","offset":0,"inContextOfComponent":"force:highlights","isDraft":false,"record":{"LastModifiedDate":"2025-02-06T20:29:30.000Z","Email":null,"FirstName":"Jonathan","AboutMe":"I use Tableau by day and write about Tableau by day and night.","PostalCode":null,"Title":null,"City":null,"MiddleName":null,"Name":"Jonathan Drummey","SystemModstamp":"2025-02-06T20:29:30.000Z","CompanyName":"PATH","CommunityNickname":"jonathandrummey","Suffix":null,"Phone":null,"State":null,"CreatedDate":"2020-04-25T13:26:52.000Z","Street":null,"Country":null,"LastName":"Drummey","Id":"0054T000001O4jxQAC","LastModifiedById":"0054T000001N0mYQAS","sobjectType":"User"},"pageSize":-1,"type":"FULL"}}},"error":[],"components":[{"componentDef":{"descriptor":"layout://rl-User-VIEW-FULL----force_highlights-_1-0-674b574567657471726c42666756465a66576b5766673d3d.c"},"original":"markup://force:recordLayout","creationPath":"/*[0]","attributes":{"values":{"mode":"VIEW","offset":0,"inContextOfComponent":"force:highlights","isDraft":false,"record":{"LastModifiedDate":"2025-02-06T20:29:30.000Z","Email":null,"FirstName":"Jonathan","AboutMe":"I use Tableau by day and write about Tableau by day and night.","PostalCode":null,"Title":null,"City":null,"MiddleName":null,"Name":"Jonathan Drummey","SystemModstamp":"2025-02-06T20:29:30.000Z","CompanyName":"PATH","CommunityNickname":"jonathandrummey","Suffix":null,"Phone":null,"State":null,"CreatedDate":"2020-04-25T13:26:52.000Z","Street":null,"Country":null,"LastName":"Drummey","Id":"0054T000001O4jxQAC","LastModifiedById":"0054T000001N0mYQAS","sobjectType":"User"},"pageSize":-1,"type":"FULL"}}}]}
Hi @Lily Hijazi (Member) ,
If you use the filter to filter out a certain Surgeon then the fiscal months shown will be the ones in the original data and therefore may not be consecutive. There are workarounds, for example, use a parameter for [Surgeon] in the calculation of [average cost], or manually create and then add a table of full fiscal year-month to the data source. Both have some shortcomings but will solve your problem where the trend line is not complete.
Best Regards,
Yuki
-
p.s.: If you finds my answer helpful, please feel free to select it as your best answer! Thanks so much!
solutions