eazyBI How to plot the element of one dimension vs a different element of the same dimension

[Roland Leber]

I will greatly appreciate if someone can help me with the following:

I want to create a Line plot with the element 'Issue Start Date' on the x-axis and a different element 'Value' on the y-axis. However, both 'Issue Start Date' and 'Value' are elements of the dimension 'Measures'. Hence, how is it possible to generate a plot of one element of a Dimension vs a different element of the same Dimension?

[Roberts Čāčus - eazyBI · Accepted solution]

Hi @Roland Leber 

I already answered your question on the eazyBI community site. I will post the answer below if someone else in the Atlassian community has a similar question.

If the ‘Value’ field is numeric, it should be tied to the date field ‘Start date’ as measure “Value with start date”. In such a case, you can use the Time dimension on report rows and select the measure “Value with start date” in Measures. The values from the numeric field ‘Value’ will be tied to the date field ‘Start date’ in the report. See an example with the numeric field “Estimated Cost” and the date field “Target start” combined in the measure “Estimated cost with target start” below:

Make sure both fields are imported as measures in the eazyBI import options. See the eazyBI documentation page for more details on date custom field import - https://docs.eazybi.com/eazybi/data-import/data-from-jira/jira-custom-fields#Jiracustomfields-Measureswithcustomdatefields.

Best,
Roberts // support@eazybi.com