Hi, As per Anapedia, I should be able to add sparklines in NUX KPI cards. (Ref: https://help.anaplan.com/anapedia/Content/New_User_Experience/Build/Boards/Cards/KPI-cards/Add-a-sparkline-to-a-kpi-card.htm?_ga=2.83131935.821100742.1592740824-605168622.1586102450) I am trying to do the same with a Time Period dimensioned line item, but I am unable to find the "Sparkline" option in the card. Not sure what am I missing here? Please refer to the view below. I have Time as 1 of the 5 dimensions in the line item. Has somebody used sparklines? Would appreciate any help on this.
... View more
Hi Mark, As suggested by Nathan this could be achieved using RANK. I am outlining the broad steps below: In EM43, create line item "Rank - Not allocated roles" to rank the #Job Roles items not allocated. Tip: Use the "Not Allocated?" boolean as " Include" parameter in the RANK formula. Line item: Rank - Not allocated roles, Format: Number, Applies to: #Job Roles Create another line item in EM 43, Line item: Not allocated roles by Rank, Format: #Job Roles, Applies to: Data List (1-100). Data list is a non production list containing numbers 1 - 100 (as many required). The idea is to transform the line item in Step 1 to a line item containing the roles dimension-ed by (1...100). i.e. Item 1 will contain first not allocated role, Item 2 will contain second not allocated role. Step 1 -> Step 2 can be easily achived using a formula (FIRSTNONBLANK) In EM42, create line item "Rank - Not allocated employees" to RANK the Employees items not allocated. Use logic similar to Step 1. In EM42, create Data List formatted line item "Rank - Not allocated employees List" based on "Rank - Not allocated employees" using FINDITEM on Data List In EM42, LOOKUP the role from line item in Step 2 using line item in Step 4. e.g. EM43. Not allocated roles by Rank [ LOOKUP: EM42. Rank - Not allocated employees List] Hope that helps. Regards, Amit
... View more