Enhancement: Allow single total values

[psheehymn]

We use a Real-User Monitoring (RUM) application to gather data about end-user experience on our web portals. We're using the Flow plugin to design flowcharts which illustrate various user journeys within the portal (main-dashboard -> claims-list -> view-a-claim-> pay-a-claim, etc.).

The Grafana plugin for the RUM tool can return either a time-series or a single value for the specified time range (the latter being a total count or an average of a time-value, depending on the metric being queried). However, when we flip the queries from time-series to single value, the values on the Flow diagram disappear.

Because our dashboards are designed for executive-level consumption, the single value (as opposed to the time-series) would actually be very useful to us. An executive could get a snapshot of the total flow of traffic for a time period (such as "yesterday") as opposed to the incremental view currently presented.

We request the capability to switch between time-series and single value for the flowchart, either thru a manual option (and please allow the option field to accept a variable to allow this to be changed dynamically) or automatically (such as if one or more of the queries returns only a single value, then the flow-chart flips to single value mode). Obviously, the time slider would be disabled or hidden in single-value mode.

Is there any reason this would not be feasible?

[andymchugh]

Can you press on 'Debugging Data' and show me what the raw data and enriched data look like? I need to know what the plugin is receiving to know how to interpret it after it's passed through the toDataFrame conversion.

[psheehymn]

Do you want both the time-series and the single value, or just the latter?

[andymchugh]

I need to see the data being given to the panel that isn't working for you.

[psheehymn]

Here's the debug data: m4-stage.optum.com-1718917550277.log

[andymchugh]

It's not really readable unfortunately. What I'm after is a minimal view of the data you want to display. It will be filtered from the -debug-data-enriched' because there's no time but will be present in the 'debug-data-raw' and in the output of grafana's query inspector. If you could show me what that data looks like for a single term I may be able to do something. But without that or instructions on how to generate such data I can't get further.

[psheehymn]

Here's an example CSV extracted from the Query Inspector in the panel of the Total version of the query. E&I Claims 01 - My Claims - Pay Now-data-2024-06-21 15_02_11.csv

For comparison, here is the exact same query, switched to return a time-series: E&I Claims 01 - My Claims - Pay Now-data-2024-06-21 15_05_11.csv

[andymchugh]

I need to understand the javascript object layout for the above. So I need a minimal example with one data term as shown in the query inspector and the 'debugging data raw'. But it has to be in the javascript object form. That's my input; the csv form doesn't tell me anything.

[psheehymn]

I am not expert with the Chrome dev tools. Your buttons obviously send the data to the console in the form you need, so I have to assume my extracts are not being done correctly. Can you walk me thru how to extract the debug data from the console so it's in a consumable format?

[andymchugh]

Reduce your panel down to just 1 data query returning just one value. Then expand out debugging data raw in the console so I can see how the structure of the incoming data. Also a screenshot of the grafana query inspector result will also help a great deal. Basically I need a readable starting point and it stops becoming readable if there's more than one query in it as its too much information.

[psheehymn]

I pared the panel down to a single query. I have included both TimeSeries results and Total (single number) results, as well as screen shots from the Query Inspector. Hopefully these can help. m4-stage.optum.com-TimeSeries.log m4-stage.optum.com-Total.log

[andymchugh]

Thanks for trying. Unfortunately it's still not really helping. The log isn't showing anything useful and the query screenshots don't show the response. It's the query response that is the input to the panel. A screenshot like this showing the query response would help:

[psheehymn]

Here is the Query JSON for both the TimeSeries and Total versions (they were too long to screenshot, so I expanded them and used the Copy to Clipboard option). QI-Query-TimeSeries.txt QI-Data-Total.txt

[andymchugh]

That's perfect. Thanks for persevering with it. I know what to do now

[psheehymn]

Awesome! Thanks Andy!

From: Andy McHugh @.> Sent: Friday, June 28, 2024 4:18 AM To: andymchugh/andrewbmchugh-flow-panel @.> Cc: Sheehy, Patrick @.>; Author @.> Subject: Re: [andymchugh/andrewbmchugh-flow-panel] Enhancement: Allow single total values (Issue #79)

Caution: External email. Do not open attachments or click on links if you do not recognize the sender.

That's perfect. Thanks for persevering with it. I know what to do now

— Reply to this email directly, view it on GitHubhttps://urldefense.com/v3/__https:/github.com/andymchugh/andrewbmchugh-flow-panel/issues/79*issuecomment-2196480206__;Iw!!IqUcNYopQPk7!I8eorEndwRWuORZ5eGumdVC1AC8O3HOB7aYtXFTvWiM4cL1wS2XgnL-RywpQvRAMDylSPJhtN9ebheX3AA765HV2uNo1$, or unsubscribehttps://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/AWHT4SXENDJ7DNXX4SMZ64TZJUS4FAVCNFSM6AAAAABJUFX2XOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCOJWGQ4DAMRQGY__;!!IqUcNYopQPk7!I8eorEndwRWuORZ5eGumdVC1AC8O3HOB7aYtXFTvWiM4cL1wS2XgnL-RywpQvRAMDylSPJhtN9ebheX3AA765Ko6AzC2$. You are receiving this because you authored the thread.Message ID: @.**@.>>

This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or intended recipient’s authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately.