Hi - Can any one suggest an idea on how to design dashboard based on the attached screen shot ? Color of the wheel should be auto populated based on the logic's set .
@bhatjaved
Is this chart dynamic in nature?. If not then you can use this as an Image on to your dashboard.
Thanks,
Misbah
Hi @bhatjaved ,
I couldn't find a chart which suffice your purpose, but I can suggest an alternative approach:
1. Create a module with 2 line items. Current Status - Boolean - Which will hold your current status based on the logic
2nd Line item - Display Status - Formula : IF Current Status THEN 1 ELSE 0. Summary - Formula.
Put a conditional format on Display Status:
So, the display status color would be based on the status logic.
Let me know if this helps.
Yash
If we go down lowest descendants for 2 hierarchies something like this {Descendants([Planning Org].[Planning Org].[ALL].[AllMember],255,LEAVES)} then the queries timeout what is the best way to use lowest decendants so it doesnt scan the whole hierarchy
Hi! In London it was mentioned, any update on this?
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
