04-13-2023 04:15 AM - last edited on 05-23-2023 04:14 AM by JackLacava
Hi everyone,
I am creating a graph in a report. This report is a component in a dashboard maintenance unit and is using a simple data adapter linked to a cube view to retrieve the data.
The graph is working. However, I would like to only show a data label based on a time selection parameter that is part of the data adapter. For instance, if I select 2022M11, I only want to see the data label for November 2022. Please see the screenshot for clarification.
So, if I select November 2022 (or any other year) I would only like to see the data label for November (I still need to work on the number formatting).
Is there anyone with experience in this and can help me? I have checked all the options but couldn't find anything. I was thinking to work with the scripts part of the report components.
Any help is much appreciated.
Thanks!
Floris van der Poel
Solved! Go to Solution.
05-03-2023 08:00 AM
Hi Jack,
I found a solution using a workaround.
The data label changes following my time selection.
I did this by creating two additional data points in the cube view feeding this chart. These data points get the data according to the time selector, and the month from the time selector.
In the chart, I added two additional series that get their data from the two additional data points. Everything but the data label is hidden. This creates the effect of only showing the data labels for the selected time.
Thanks for your help.
Floris
04-16-2023 06:22 AM
I don't have a solution right now, but I can suggest a possible source of information about advanced features of the Report component. If you go to the Marketplace and select the Platform section, then change the platform version to 7.0, you can download a version of the On-Prem Server & Documentation package that still includes guides for the old Reporting Studio - the direct predecessor of that component. It contains a lot of information that is still valid (and not available anywhere else) for the Report Component.
04-16-2023 10:33 AM
Fantastic! I will have a look. Will share if I got something.
Thanks Jack.
05-03-2023 08:00 AM
Hi Jack,
I found a solution using a workaround.
The data label changes following my time selection.
I did this by creating two additional data points in the cube view feeding this chart. These data points get the data according to the time selector, and the month from the time selector.
In the chart, I added two additional series that get their data from the two additional data points. Everything but the data label is hidden. This creates the effect of only showing the data labels for the selected time.
Thanks for your help.
Floris