Best Of

Change value formatting based on KPI selected in variable

I have a card that allows the user to select which metric (Sales, Units, Margin %, etc) they want to graph by, using a variable control.

Is there a way to force data formatting to be 'currency' when 'sales' is selected for example? Then when a user selects 'units', we'd want the formatting to now be shown as 'number'. With margin %, we'd have it automatically format as a 'percentage'.

Thanks in advance,

Michael

M_Gonzalez

1

Re: What are my options for connection Microsoft SSRS to Domo?

You may be able to automate sending an email and using the Dataset via Email connector - See https://learn.microsoft.com/en-us/sql/reporting-services/subscriptions/e-mail-delivery-in-reporting-services?view=sql-server-ver16

Alternatively, if you want to be more technical you may be able to write a custom connector and leverage SSRS's REST APIs: https://learn.microsoft.com/en-us/sql/reporting-services/developer/rest-api?view=sql-server-ver16

GrantSmith

1

Re: Historical Data Reporting

@EmmaDonery Can you share a little bit about what data you currently have available and what you want to do with it? If you need to take snapshots at particular points in time, then a recursive dataflow would likely be your bet bet. Otherwise there are some other methods you could use by categorizing and appending data within a non-recursive dataflow.