I have a daily sales report, but sales are accumulated, and ...

[NYCBabak .]

BY HIGHEST 1 REPORT_DATE

[JUAN ORTIZ]

This is so weird, it works on a Gauge Chart but it does not work on a Gauge Visualization

[JUAN ORTIZ]

Thanks, @NYCBabak

[JUAN ORTIZ]

I have a daily sales report, but sales are accumulated, and I would like to add a gauge visualization to show the results for the last day only. This gauge shows values for every single day, but I only need to show the last available day. In SQL , this would something like:

Where Report_Date = (select Max(Report_Date) from Table)

How can I achieve this in WebFocus 8206