Get max Value every Day

i used grafana 7.5 and Prometheus;

my data:

my_total{app=“portal”,module=“java”,} 20.0
my_total{app=“portal”,module=“python”,} 33.0
my_total{app=“portal”,module=“ruby”,} 16.0
my_total{app=“portal”,module=“go”,} 7.0
my_total{app=“portal”,module=“c”,} 15.0

and my data will be cleared every morning,i used bar gauge now

i want sum by module and every day max(or last not null) value
i want sum by module and every day max(or last not null) value
i want sum by module and every day max(or last not null) value

my query is

my_total{job=“$job”,app=“$appRepeatVar”} != 0

$appRepeatVar → i have multiple app, and i used repeat panel

------------------------try-----------------------------------

i have try set Min step → 1d and panel → Display → Calculation = total

it’s look’s like i want, but the data does’t contain today data

i don’t know how to write the query for i want, thank guys…

49A332BD

Welcome @jameszrepo

If you upgrade to Grafana 9 or higher, there are PromQL helper functions that may help you.

At the very least, have you explored this page? Open up any of the queries and then build / test / modify the query, or see the “Kick start your query” button.

sorry, i can not upgrade my grafana,the grafana installed of our client,and i hava try that page ,but did not help for me