About marcpaige

marcpaige · 11-20-2023

This came up in a conversation with one of my analysts.Which of these will perform better in a filter?1) Two filters: date1 >= $lastMonthStart and date1 < $currentMonthStartor2) One filter formula with and(date1 >= $lastMonthStart, date1 < $currentMo...

marcpaige · 09-06-2023

I am struggling with this new insight. Please provide some guidance by example on its use.

marcpaige · 09-06-2023

I am trying to get a solid gauge to work with a number range. Here is the setup:min = 150, max = 220first range = 96; red, second range = 95;orange, third range = 90; green in this order.The value being returned from the measure is 203. I expect the ...

marcpaige · 09-06-2023

Each insight showing a number is difficult to see in dark mode. For example, the solid gauge shows the number with a dark border that makes them seem fuzzy. It is worse for column and bar charts that show the number. Please see the screenshots below....

marcpaige · 09-06-2023

Please consider adding color ranges to the liquid gauge with a similar behavior as the solid gauge.

marcpaige · 09-08-2023

@anurag I liked the technique in the video. I put a comment on it. There is a limit to int() for conversion. I ran into this with very large millisecond counts. I was successful in using long() for the conversion with formatDuration().

marcpaige · 09-08-2023

Thank you so much! That is perfect.

marcpaige · 09-08-2023

Thank you. This makes sense. Would you be able to show the formulas used in Screeshot2?

marcpaige · 09-08-2023

Thanks, Joe. I will play with the order. I will look, but do you know if there is a plan to allow reordering the gauge ranges via drag and drop? In this particular case, I have to do quite a bit of work to reorder by creating additional ranges and de...

marcpaige · 09-06-2023

BTW, this is also a problem for the Gauge insight. It is slightly different, however. The problem with the gauge is that the Stop(%) values need to be calculated precisely with the range-to-value ratio.

User Statistics

User Activity

Which performs better for date inclusion?

Dual KPI Insight Usage and Example

Solid Gauge Ranges for non-percent base

Review all insights with numbers for Dark Mode

Color range for the Liquid Gauge

Re: calculate average time from string type

Re: Dual KPI Insight Usage and Example

Re: Dual KPI Insight Usage and Example

Re: Solid Gauge Ranges for non-percent base

Re: Solid Gauge Ranges for non-percent base