The aim is the show the % controlled for the last full month in the period - and this works correctly, it shows Nov in this case.
The problem I am facing is that when I change the period using the ‘add filter’ option on the dashboard and select a different period the highlighted number becomes an average of all months in the period - I want to just display the value for the last month in that period.
In the image above the ^% should show as 8% as this is the last month in the period.
I have a similar issue with the # controlled BP card in that it sums the values (rather than avg) but I also want to show only the last month in the period. You can see in the images above that 798 is the value for nov-2023 and in the 2nd image its suming the numbers to 4,700 rather than showing 798.
Thank you for the post with the description and screenshots. If I understood correctly, you want the filter to not affect certain visualizations? For instance, when adding a filter, you’d want % Controlled BP to remain the same while the other visualizations change? However, the dashboard filters affect all the visualizations in the dashboard - so this is a feature request!
If you want the average and not the sum of the # Controlled BP then you’d need to use an indicator that’d calculate the average. I understand that what you are asking for is to be able to find the count when it’s an individual month and to see the average when it’s more than one month? It’s not actually possible unless you create two indicators, one for count and one for average.
Please feel free to clarify anything that I might have missed. Thanks!
To clarify, I want the last month value in the period for both - ‘% controlled BP’ and ‘# controlled BP’
For example, if a user selects Oct-2023, Nov-2023 and Dec-2023 from the Add filter > period selector in the dashboard, I want to only show the value for Dec-2023. It currently Is using all 3 values to display a number rather than just dec-2023
Currently when the value is a percentage the card displays the average of the values in the period
Currently when the value is a number the card displays the sum of the values in the period.
Its important to note that there seems to be a last value option in the visualizer, but it seems to show the last value entered in the month rather than taking a total from the entire month period.
For the initial data setup I am using the ‘Last month’ option on the chart. This shows correctly when I view the dashboard in its base state.
The issue is that when a user selects a different period from the filter options on the dashboard, this card then shows a sum of each of the months in the period, I want to only show the last month of all months selected.
It seems you want one visualization to be “static” while the other should change based on the periods you select. I think the intent with the feature was to allow users to view different time intervals easily, and the visualizations would automatically update and be consistent with each other. So, looking at the right card (4700 for number of patients) should this also show the last month when you select “Last 12 months”? If so, then the %controlled BP becomes tricky to interpret, since you would expect it would be 8% of 4700 (the sum over 12 months).
I think the issue becomes it would become quite misleading to users if parts of the dashboard show one time period, while another part of the dashboard is not based on the same time period. So, I am not certain there is a way to do this, or even if its a good idea. You could maybe experiment with the “LAST_VALUE” aggregation and see if that gives you what you want though?
