Ranking in Lens Formula Features Visualization

[aisyaharifin (Siti Nuraisyah)]

Hi,

I have problem in ranking my visualization dashboard.

I would like to visualize Top 10 Uptime Monitor Availability.

I already tried using the TVSB visualization type which is Top N to visualize Top 10 Uptime Monitor, and using the Filter Ratio to display my Uptime Availability percentage.

However, the Uptime Availability percentage seems wrong.

Thus, I use the Lens visualization which is Bar horizontal type to visualize my data.

I use the Formula features to calculate my Uptime percentage and the data is displaying correctly.

However, I would like to rank my Uptime Availability Formula that I already created in ascending order, but I unable to do so.

It seems like I only able to rank it by Vertical Axis which is not meaningful to me as I would like to rank my Uptime Formula that I already created in Horizontal Axis.

Is there any KQL syntax for ranking it by ascending order that I could apply in my Uptime Availability Formula ? Or is there any other options I could rank my Uptime Availability Formula in ascending order?

Thank you.

[stephenb (Stephen Brown)]

Yeah, that is an issue in Lens... What version are you on?

I think the rank by the formula is on the roadmap but it is not there today

[aisyaharifin (Siti Nuraisyah)]

Hi Stephen,

Thank you for your reply.

I see so that is an issue in Lens. I'm in version 8.6.1.

[stephenb (Stephen Brown)]

Yeah I tried 8.6.2... still not there...

Strangely the Pie Chart seems to give a better representation today, but yes I like the Horizontal Top-N better for a number of use cases.

On the TSVB go into the panel option and try setting Full Time Range .. .otherwise the calculation is just using the last bucket which for 15 Munites is like the last 30 seconds

[aisyaharifin (Siti Nuraisyah)]

I see the ranking features still not there.

Already set the Top-N data as the entire time range before this, not sure why the calculation from my Lens Formula and the Filter Ratio is not the same.

The 100% Uptime Percentage is the one I use Lens formula to calculate the Uptime Availability and the Top-N percentage ones is not the same.

I believe that Filter Ratio is an aggregation to display percentage.
Not sure why the value is not the same.

[Marco_Liberati]

Hi @aisyaharifin

unfortunately it is not possible to rank by a formula due to some technical challenges, same applies also for other calculations like moving averages and differences.
As a workaround in Lens has been introduced the custom metric ranking (like the agg-based editor had).

[aisyaharifin (Siti Nuraisyah)]

Hi Marco,

Thank you for your reply, but I'm sorry I didn't quite get you. Does this mean that I could not rank my Lens Formula due to the technical challenges?

Is this because Lens has introduced the custom metric ranking as in the image below?

[Marco_Liberati]

Lens formula happens on the client side, so the server cannot know the final metric in order to rank.
The custom metric workaround is a way to handle some of these cases, but I understand it won't cover all of them.