ContributionsMost RecentNewest TopicsMost LikesSolutionsRe: Preserving YTD after date filter applied I generally use an sql window function when importing the table, ie "over partition by..". Given what is shown is a pivot I assume your data does not already look like that so I could not give you the exact query just the method Re: Preserving YTD after date filter applied Faced with a similar problem, my solution was to add another column into the table of the elasticube/live which was the cumulative YTD sum and display as a table in place of a pivot. Unfortunate to have to work around, but others might have more convenient solutions. Re: Exporting Widget to PNG not utilizing dashboard filters Just an interim solution, but utilizing the SisenseJS library, the widget can be loaded as an HTML element with dashboard filters. Once loaded as a HTML element, it can be turned into a png using HTMLtoCanvas or similar. Would be great to have this available via their api but this solution works for now for me. Exporting Widget to PNG not utilizing dashboard filters When exporting a widget using the rest API, the result does not include the dashboard filters that affect that widget, is there a way around this. Also is there a method to remove the dashboard title from the PNG that is returned? Solved