Slicer instead of hardcode

[eacy]

Hi,

Could anybody guide me how to use a slicer instead of having hardcoded value. I am having a custom column where I have hardcoded "assignee" and would like to have a slicer that would change the value to i.e. "status".

Slicer = CALCULATE(VALUES('jiradb changeitem'[FIELD]);
	FILTER('jiradb changeitem';'jiradb changeitem'[FIELD] = "assignee" && 'jiradb changegroup'[ID] = 'jiradb changeitem'[groupid]))

Any suggestion is appriciated.

[Anonymous]

Hi @eacy,

   let me understand...you want a slicer made by a chart that runs on not duplicated values and that checks that the values of the [FIELD] column must be "assignee" and that values of the [groupid] column must be the same of the [ID] column of another table. Am I right?

Just like @austinsense have said, if you give us some dataset samples or some screenshots we can help you better.

#I'M Not An Expert#

[eacy]

Earlier Change (M) = 
IF('jiradb changegroup'[ID] > 0;
DATEDIFF(
	CALCULATE(MAX('jiradb changegroup'[CREATED]);
		FILTER(ALL('jiradb changegroup');
			'jiradb changegroup'[issueid] = EARLIER('jiradb changegroup'[issueid]) && 
			'jiradb changegroup'[CREATED] < EARLIER('jiradb changegroup'[CREATED]) &&
			NOT(ISBLANK('jiradb changegroup'[Slicer]))
	));'jiradb changegroup'[CREATED];MINUTE)
;BLANK())

Slicer = CALCULATE(VALUES('jiradb changeitem'[FIELD]);
	FILTER('jiradb changeitem';'jiradb changeitem'[FIELD] = "assignee" && 'jiradb changegroup'[ID] = 'jiradb changeitem'[groupid]))

Hi,

I would like to be able to fetch the value of the slicer and replace the hardcoded "assignee".

So, the slicer should slice the tabel but also give me input to the calculation I make in the "Earlier Change (M)" which calculate the time from the previous row with the same "FIELD" value.

Right now it calculate the time from the previous row no matter which value it has.

Thanks for your effort

[austinsense]

I don't really understand the question - could you explain it again, maybe show some screenshots?

[eacy]

Hi Austin,

Please see my comment below