Best Of

You’ll need to have a record for each rep for each day. To do this you can import the Calendar.csv from the Domo Dimensions connector. Then run a select columns on your dataset to pull just the rep name. Run that through a distinct tile. Then for both of those use two separate Add Contant tiles to add a column called Join Column and set the value to 1. Then use a join to join both datasets based on the join column. You can filter your dates to ignore ones in the future and any dates prior to the earliest sales rep date. Take this joined column dataset and left join your original dataset to it you should now have records for every rep for every day. You can then use a formula tile to do a COALESCE function to default any nulls to 0

Hi @PankajDG, there's currently no way to add in multiple manual scale markers on a single chart. What is available is using Quantiles, which equally divides the area between your chart's minimum and maximum values (e.g. 5 quantiles = 3 regions closest to average appearing shaded). Unfortunately in breaking the chart into these regions, a single colour is only available.

@newbee do you have dataset access? You can get this from the Domo Governance connector using the "Beast Modes"report - then you could create a view on top to filter by the dataset you are concerned with.