Ayantek
Cloud Apps
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: Pivot conditional coloring based on time
Hi rahuldhomane , In the values section, there will be a color palate icon beside the toggle button, when we click on that it will open a window where we can give conditional coloring. I have attached a sample example, hope this helps. Thanks Ayantek4.1KViews3likes0CommentsRe: Formula for count with filter
Hi Akhila , Please right-click on the dimension which is "age filed filter by value between 20 to 40" in your case and filter out which value you are looking for, attached screenshot for your reference. (count([Brand ID]),[Age Range1]) Ayantek.5.8KViews1like0CommentsRe: Using answer to a calculation within another calculation
Hi CLewis , I have faced a similar kind of use case to bring count and sum excluding a category in the pivot. Below is the analysis: For SUM its a straightforward with ALL function but for count, we need to check for all the filters we added in both the widgets, attaching a few screenshots for your reference. this is the formula I used to get %percentage (([# of unique Brand ID],All([Gender]))/([# of unique Visit ID],All([Gender]))) In your case, you need to add JobID in All(JobID) both in numerator and denominator. Hope this helps. Ayantek.6.5KViews2likes0Comments