Nexus Threshold Analysis - Data App
Data App automates the calculation steps for sales tax report for the subscription data with dynamic selection of the 12-months period. Based on the user-specified start date of the taxation period, the Data App will automatically take the active membership falling into this period and compute the total sales per state based on the subscription fee.
Nexus Threshold Logic:
- Sum up sales by state.
- Compare total sales by state with nexus threshold for that state.
- Highlight the states where nexus threshold on a US map for visualization.
Read more on the topic Sales Tax Reporting on the KNIME Blog: https://www.knime.com/blog/sales-tax-reporting
URL: KNIME Blog: Sales Tax Reporting https://www.knime.com/blog/sales-tax-reporting
URL: US States Boundaries Data https://www.census.gov/geographies/mapping-files/time-series/geo/carto-boundary-file.html
Nodes
- Rule Engine Variable37 ×
- String Manipulation (Variable)27 ×
- Merge Variables25 ×
- Math Formula (Variable)18 ×
- Table Row to Variable18 ×
- String Configuration17 ×
- CASE Switch Variable (End)15 ×
- Single Selection Configuration15 ×
- Breakpoint13 ×
- Column Filter13 ×
- Column Selection Configuration13 ×
- CASE Switch Variable (Start)12 ×
- Row Filter10 ×
- Table Creator8 ×
- Column Rename6 ×
- Counter Generation6 ×
- Extract Table Dimension6 ×
- Extract Variables (Data)6 ×
- Inject Variables (Data)6 ×
- Transpose6 ×
- Expression5 ×
- Variable to Table Row5 ×
- Date&Time Difference4 ×
- Empty Table Switch4 ×
- Generic JavaScript View4 ×
- Boolean Configuration3 ×
- CASE Switch Data (End)3 ×
- CASE Switch Data (Start)3 ×
- CSS Editor3 ×
- Column Auto Type Cast3 ×
- Column Combiner3 ×
- Column Renamer3 ×
- Excel Reader3 ×
- File Upload Widget3 ×
- Integer Configuration3 ×
- Joiner3 ×
- RowID3 ×
- Rule-based Row Filter3 ×
- Rule-based Row Splitter3 ×
- Text View3 ×
- Duplicate Row Filter2 ×
- String to Date&Time2 ×
- Color Manager1 ×
- Concatenate1 ×
- Date&Time Configuration1 ×
- Date&Time Shift1 ×
- Date&Time Widget1 ×
- Date&Time-based Row Filter1 ×
- Excel Writer1 ×
- File Download Widget1 ×
- GroupBy1 ×
- Refresh Button Widget1 ×
- String Manipulation1 ×
- Table View1 ×
- Value Lookup1 ×
- Variable Creator1 ×
- Variable to Table Column1 ×
Extensions
- FeatureKNIME Base nodes
- FeatureKNIME Data Generation
- FeatureKNIME Excel Support
- FeatureKNIME Expressions
- FeatureKNIME JavaScript Views
- Show all 9 modules
Links
- No links available