1 Reply Latest reply on Nov 4, 2016 10:06 AM by Yuriy Fal

# Periodically Project Status in Tooltip

Hello vizzers,

I want to combine different techniques to visualize the Project Status in a Tooltip.

Each project has its project status consisting of several indicators which are collected periodically mid month.

This sounds like I need a LOD Calculation using {FIXED } but I have issues combining it with the latest period date.

I only want to see the latest entry and visualize it in the tooltip.

My problem is, that the tooltip shows now multiple dots because it is not considering the latest period but all periods...

So I though I just need to take the MAX([PeriodStartDate]) and combine it with a LOD Calc. I saw something similar here:

Where they use the LEFT() function to determine the # of dots to visualize, for me it would be 0 or 1.

Example:

LEFT("●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●●",

{fIXED [Season], [Game] : MAX(IF [Team] = 'Florida State' AND [Quarter as Numeric] = 1 THEN [Score] END)})

But I can't get the latest period start date because I can't compare Boolean and Date or Agg and non-Agg values :\

This is what I tried but failed with errors:

LEFT(IIF([Status] = "Green", "•", ""),

{ FIXED [Project ID]: IF MAX([Report Period (Start)]) = [Report Period (Start)] THEN 1 ELSE 0 END})

With error: Cannot mix agg and non-agg arguments with this function and pointing to the equal sign.

Anyone can help me?

I will setup a sample workbook but I need some free time for that. Maybe you can help me already with the information provided.

Cheers.

• ###### 1. Re: Periodically Project Status in Tooltip

Hi Ahmed,

You'd like to try it like this:

LEFT(IIF([Status] = "Green", "•", ""),

IF { FIXED [Project ID]: MAX([Report Period (Start)]) } = [Report Period (Start)]

THEN 1 ELSE 0 END )

Yours,

Yuri