Scatter Chart with Date on X axis and only one expression (Amount) on Y axis
Hi Everyone,
I am trying to build Scatter chart with Transaction date on X- axis and Spend Amount on Y- axis (only one expression).
I am giving the expression = only([Spend Amount]), as I want to show just spend amount without any aggregations.
Dimension as "Transaction Date".
Based on the spend amount I need to give color codes, for high spend it is "red" color, for medium spend it is "golden" color and for less spend it is "Green".
Can you please let me know how to build the scatter chart with above requirement.
I have tried all the ways and tried combo chart also, but user want only Scatter chart representation.
