Good Morning,
I have a data cube that has 30-40 fields that are datetime data types. I’d like to create a dashboard that has two drop downs where I can select a field in each and then have a datalabel that calculates the average difference in days between those two dropdowns with the data fields.
Hi Brandon,
My first instinct on this is to create a stored procedure with two input parameters (FieldA, FieldB) and simply output a consistent structure. If you do this, you can parameterize the input to the stored procedure from drop downs directly on the dashboard.
You can do this with scripting if you prefer JavaScript but i feel like the data side is easier.