I have a date field that is set as a date type. I can change aggregation in my line chart visual in the analysis both in the visual and on the field well without issue. I can’t do this in the dashboard though. My end users need to be able to see the data by various date aggregations. Documentation I’ve read indicates this should work, but I don’t have the ability to change the aggregation type in the published dashboard version of the analysis. Am I missing something or is this not possible to do in the dashboard?
Hi @jonfrank3366,
The easiest/quickest way to handle this (which would require your sheet to be in free form); would be to create copies of your visual, one for each time aggregation.
Then, create a custom drop down parameter for those time aggregations (you’ll create a string parameter though) and add a control on the sheet for it.
Last, you’ll create a rule for each of your visual copies. You’ll set them to match the parameter you just created (I.E. When parameter equals ‘Day’, show the ‘by day’ visual.
Check out this Arena View where I setup this scenario and let us know if you have any additional questions
Thank you for sharing. I appreciate the thoughtfulness and effort. Is there not a simpler way to handle this though? This seems like something really basic that any BI tool should be able to do, provided the date field is formatted as a date type.
