Solved

How can you show Average daily values of a chart in a dashboard?

  • 25 April 2023
  • 2 replies
  • 473 views

​Lets say I have 3 segments showing the uniques of a given event, and I want to show on a dashboard the daily average uniques of each segment during the given time period (in this case 30d).
In the line chart I can chose Average Values to get those metrics:

However if I show this chart in the dashboard I can not get the average metrics.
In the KPI options its not available:

IF I change to the table view I can get the current day, and the previous day but not the Average.

I could try change the chart to a Bar chart in order to force only have one value for the period, BUT that would no longer be the average during the period but rather the deduped uniques during the total period.
 
I can not think of a formulario or rolling avg o window to get Daily average uniques for the given time period as a single metric to then show on a dashboard.
For now the option is to have the Average value as the metric on the Line Chart, have the line chart on the dashboard, and the user then needs to enter into the chart to see the average.

icon

Best answer by Saish Redkar 25 April 2023, 19:38

View original

2 replies

Userlevel 7
Badge +10

Hi @joel.spiro 

You are correct. That’s the current limitation of dashboard view which doesn't allow much for metric customization. For daily averages, you will have to have to click in the chart and look at Average Value across your 3 segments or the Row Average Column of the breakdown table underneath.

 

Userlevel 5
Badge +9

@Saish Redkar thanks so much for jumping in here! @joel.spiro I’ve also asked our team to look further into this in case they have additional suggestions!

Reply