How to show issue count for each plotted point in scatter plot chart


#1

Hallo,
I would like to show the issue count on each plotted point to avoid overlapping plots. An example would be to use all issues in the row and two custom fields in the measures (single-select 1…4). I can display a normal plot by CF values, but these tend to overlap due to shared values. (use-case is a risk/impact plot of issues)

I would be grateful for any help or better suggestions :slight_smile:


#2

Hi Mark,

I am not sure the scatter chart would be that flexible.
The closest workaround I found is a table report view after you define your custom fields via eazyBI advanced settings to import both of them as dimensions and then use in separate axis

Otherwise, the behavior in scatterchart is as you describe - issues would overlap in case of identical values in both custom fields.

Martins / eazyBI support


#3

Great news.

We just figured out a workaround to make scatter chart sum issues created and still show them on two separate axes where each of them shows values from a different custom field (see below) imported as a dimension.

You could reach out to eazyBI support for more details on this workaround.

Martins / eazyBI support


#4

Hallo Martins,
Thank you for the response. Could you please expand the definitions of the two user defined measures. I am still defining these false in my case as I only get empty values.
Bets regards,
Mark

PS. What is meant with “You could reach out to eazyBI for more details” … is it desired that in such a request I open an issue with support?


#5

Hi Mark,

Yes, I recommended to reach out to eazyBI support by sending a question directly to us as this use-case may require additional communication in case you need more detailed steps to import both of your custom fields as dimensions and then create new calculated measures for this specific use-case.

Anyway, after you have imported your two custom fields as separate dimensions, you could create new calculated measures that would return the dimension member names in separate columns.

This is the code I used for my calculated measure: “Value integer”

CASE WHEN
[Measures].[Issues created]>0
THEN
Val([TCV value].CurrentMember.Name) --member from new dimension
END

A similar code I used for “Comment (integer)” measure.

CASE WHEN
[Measures].[Issues created]>0
THEN
Val([Comments].CurrentMember.Name) --member from new dimension
END

Martins


#6

Hallo Martins,
Thank you very much for your assistance. The information you have provided should suffice. I will contact support for further help if needed.
Best regards,
Mark

PS. It is a pleasure to see the commitment made by EazyBi to the Community. Thanks!