maddymorningsta
Data Storage
Joined 2 years ago
User Profile
User Widgets
Contributions
Creating A Burndown Chart In Sisense
Hi all, I want to create a burndown chart with my planned and actual hours for a project across time. I'm unsure what functions would be best to use here - has anyone created one in Sisense before and would like to give any advice? Would I use the RSUM function?864Views1like1CommentTransferring Grand Total from Pivot when converting widget to Indicator?
Hi all, I am using this formula to flag a 1 for every project that is at or under budget. SUM(CASE WHEN ([Total budget] - [Total amount]) >= 0 THEN 1 ELSE 0 END) This works fine as a pivot table since there is an option to display a grand total. However, this widget needs to be an indicator, and I'm noticing that the grand total does not come through when changing from pivot to indicator. Instead, the Indicator total is displayed as "1". Choosing the option "Running sum by category" also displays a 1. Is there a way around this? ThanksSolved1.7KViews0likes2Comments