I have a requirement which goes like this :
I have a dashboard in which there are around 25 metrics. On clicking each metric a summary report opens up. So in all there are 25 summary reports. Now the user wants a single generalized summary report meaning on clicko of any metric this single generalized report should open. This report has the following prompts :
Date
Region
Name of the metric
One possiblity of achieving this is by using conditional blocks. But the only problem is the design would be a big mess and the report would run for ages..
Can anyone suggest any other alternative
You could use a token macro prompt for the metric column.
You get your metrics prompt so that use value is [package]. [namespace]. [query subject]. [metric] and the display value is the name of the metric. Then, your metric column should be
#prompt('metric parameter name', 'token', 'default metric') #.